Monitoring Parameters

SnmpTrapDestinationsList

Defines where Vertica sends traps for SNMP. See Configuring Reporting for SNMP.

Default Value: none

Example:

ALTER DATABASE mydb SET SnmpTrapDestinationsList = 'localhost 162 public';

SnmpTrapsEnabled

Enables event trapping for SNMP. See Configuring Reporting for SNMP.

Default Value: 0

Example:

ALTER DATABASE mydb SET SnmpTrapsEnabled = 1;

SnmpTrapEvents

Define which events Vertica traps through SNMP. See Configuring Reporting for SNMP.

Default Value: Low Disk Space, Read Only File System, Loss of K Safety, Current Fault Tolerance at Critical Level, Too Many ROS Containers, WOS Over Flow, Node State Change, Recovery Failure, Stale Checkpoint, and CRC Mismatch.

Example:

ALTER DATABASE mydb SET SnmpTrapEvents = 'Low Disk
Space, Recovery Failure';

SyslogEnabled

Enables event trapping for syslog. See Configuring Reporting for Syslog.

Default Value: 0

Example:

ALTER DATABASE mydb SET SyslogEnabled = 1 );

SyslogEvents

Defines events that generate a syslog entry. See Configuring Reporting for Syslog.

Default Value: none

Example:

ALTER DATABASE mydb SET SyslogEvents = 'Low Disk
Space, Recovery Failure';

SyslogFacility

Defines which SyslogFacility Vertica uses. See Configuring Reporting for Syslog.

Default Value: user

Example:

ALTER DATABASE mydb SET SyslogFacility = 'ftp';