SNMP on the DCA

1. The Greenplum Database system can be configured to trigger SNMP alerts or send email notifications to system administrators whenever certain database events occur. 

2. These events can include fatal server errors, segment shutdown and recovery, and database system shutdown and restart.

3. The Greenplum DCA has a SNMP version 2 management information base (MIB).

4. The MIB can be used by enterprise monitoring systems to identify issues with components and services in the DCA.

5. The DCA MIBs are located in the following locations: /usr/share/snmp/mibs/GP-DCA-TRAP-MIB.txt, /usr/share/snmp/mibs/GP-DCA-DATA-MIB.txt

How to enable system alerts and email notifications? click here

Change the SNMP community string

he SNMP community string can be modified through the DCA Setup utility. Changing the SNMP community string through DCA Setup will update all hosts in the

DCA. Follow the instructions below to modify the community SNMP string.

The following restrictions apply when modifying the community SNMP string:

1.  The Greenplum Database must be version 4.1.1.3 or later. If the Greenplum Database is a version earlier than 4.1.1.3, the option to modify the SNMP

community string will not be available.

2. If the DCA cluster is expanded with new hosts, the new hosts will not use the default SNMP configuration by default. The updated SNMP configuration

must be copied from an existing host to the new hosts.

3. If the SNMP community string is modified while running Greenplum Database 4.1.1.3 or later, and the Greenplum Database is downgraded to a  version earlier than 4.1.1.3, the modified SNMP file will not function properly. Also, dial-home and health monitoring will be affected.

1. Open an SSH connection to the Primary Master server and log in as the user root.

2. Start the DCA Setup utility:

# dca_setup

3. Select option 2 to Modify DCA Settings.

4. Select option 20 for Health Monitoring.

5. Select option 7 for snmp_community.

6. Enter the new SNMP community string:

Enter the SNMP community string [public]:cust-string

7. Select option 1 Apply Changes.

8. Enter y to accept changes.

Set a SNMP Trap Sink

Up to 6 SNMP Trap Sink servers can be specified through the DCA Setup utility.

Follow the instructions below to set Trap Sink servers:

1. Open an SSH connection to the Primary Master server and log in as the user root.

2. Start the DCA Setup utility: # dca_setup

3. Select option 2 to Modify DCA Settings.

4. Select option 20 for Health Monitoring.

5. Select option 8 through 13 to set trapsink_hostname1 through trapsink_hostname6.

6. Select option 1 for Change this trapsink.

7. Enter the trap sink server in the format hostname or hostname:port: Enter snmp trap destination 1: trapserver1

8. Select option 1 Apply Changes.

9. Enter y to accept changes.