emcconnect_history
The emcconnect_history
table displays information about ConnectEMC events and alerts. ConnectEMC events are triggered based on a hardware failure, a fix to a failed hardware component, or a Greenplum Database instance startup. Once an ConnectEMC event is triggered, an alert is sent to EMC Support.
This table is pre-partitioned into monthly partitions. Partitions are automatically added in one month increments as needed. Administrators must drop old partitions for the months that are no longer needed.
Note: This table only applies to Greenplum Data Computing Appliance platforms.
Column | Type | Description |
---|---|---|
ctime |
timestamp(0) without time zone | Time this ConnectEMC event occurred. |
hostname |
varchar(64) | The hostname associated with the ConnectEMC event. |
symptom_code |
int |
A general symptom code for this type of event. For a list of symptom codes, see the EMC Greenplum DCA Installation and Configuration Guide. |
detailed_symptom_code |
int | A specific symptom code for this type of event. |
description |
text | A description of this type of event, based on the detailed_symptom_code . |
snmp_oid |
text | The SNMP object ID of the element/component where the event occurred, where applicable. |
severity |
text | The severity level of the ConnectEMC event. One of:
|
status |
text | The current status of the system. The status is always OK unless a connection to the server/switch cannot be made, in which case the status is FAILED . |
attempted_transport |
boolean |
|
message |
text | The text of the error message created as a result of this event. |