Pivotal Knowledge Base

Follow

SNMP Monitoring Matrix for Greenplum Database

Environment

 Product  Version
 Pivotal Greenplum   4.3.x

Purpose

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

The alerts and notifications contain Object IDs (OIDs) and SQL error codes.

Description

The MIB matrix for Pivotal Greenplum uses the following OID: 1.3.6.1.4.1.31327.1

iso(1)
identified-organization(3)
dod(6)
internet(1)
private(4)
enterprises(1)
gpdbMIB(31327)
gpdbObjects(1)


Pivotal Greenplum will send the SNMP alerts with a range of detail from:
1.3.6.1.4.1.31327.1.1 to 1.3.6.1.4.1.31327.1.6

These messages will include Error level, message, segment information and other details:

gpdbAlertMsg
1.3.6.1.4.1.31327.1.1: STRING: alert message text

gpdbAlertSeverity
1.3.6.1.4.1.31327.1.2: INTEGER: severity level

  gpdbAlertSeverity can have one of the following values:
  gpdbSevUnknown(0)
  gpdbSevOk(1)
  gpdbSevWarning(2)
  gpdbSevError(3)
  gpdbSevFatal(4)
  gpdbSevPanic(5)
  gpdbSevSystemDegraded(6)
  gpdbSevSystemDown(7)

gpdbAlertSqlstate
1.3.6.1.4.1.31327.1.3: STRING: SQL standard error codes

gpdbAlertDetail
1.3.6.1.4.1.31327.1.4: STRING: detailed alert message text

gpdbAlertSqlStmt
1.3.6.1.4.1.31327.1.5: STRING: SQL statement generating this alert if applicable

gpdbAlertSystemName
1.3.6.1.4.1.31327.1.6: STRING: hostname

Additional Information

Pivotal Greenplum Database also supports:

  • RDBMS (rfc1697) and
  • NETWORKSERVICES (rfc2788)

For more information, refer to:

 

 

Comments

Powered by Zendesk