Events table (EVENTS)
IBM® Sterling Control Center Monitor reports contain various data fields from the Events table.
| Element | Type | Description |
|---|---|---|
| ACTION_ID | varchar | Name of an action that is called by a rule. |
| ACTIONS_COMPLETED | bigint | Indicates if the IBM Sterling Control Center
Monitor actions are completed. The
following are possible values: Null=Actions not completed Timestamp=Actions completed This element is used for restarts. |
| ALERT | char | Indicates if an alert was triggered. The following are possible
values: Null=No alert 0-3=Alert severity |
| ALERT_DELETED | char | Indicates if the alert was deleted. The following are possible
values: Null=Alert not deleted Y=Alert deleted |
| ALERT_DELETED_BY | varchar | IBM Sterling Control Center Monitor user name of the person who removed the alert. If the alert was deleted by a rule, this field contains “unknown.” |
| ALERT_DESC | varchar | Comments that are entered by the user when the alert was deleted. |
| ALERT_UPD_TIME | bigint | Time that the alert was updated, in Java epoch time stamp format. |
| DATE_TIME | varchar | Date and time that the event was generated. Format yyyy/mm/dd hh:mm:ss.msmsms. |
| DEST_FILE | varchar | Destination file name in a copy operation. |
| EMAIL_FLAG | bigint | This field is used by IBM Sterling Control Center
Monitor for recovery purposes. When a
rule matches an event, the associated action is run. If the action includes sending an email, this
flag updates after the email is sent. The following are possible values: 0=No email sent >0=email sent The value is set to zero if nothing was done, but is set to the Timestamp if something was done. |
| EVENT_ID | bigint | ID number that is assigned by the system to each event. |
| EVENT_TYPE | bigint | Code indicating the type of event. |
| FILE_SIZE | bigint | Size of the file that is transferred by the Sterling Connect:Direct® Process or Sterling Connect:Enterprise® batch. |
| FROM_NODE | varchar | Server that sent the file. The following are possible values: P=Pnode was sending server. S=Snode was sending server. |
| IBM Sterling Control Center Monitor message ID issued with the event. | ||
| NODE_ID | varchar | Server name of alias. |
| NODE_TYPE | varchar | Code indicating the type of server. The following are the server types: 0=IBM Sterling Control Center Monitor 1=Sterling Connect:Direct 2=Sterling Connect:Enterprise 3=Sterling B2B Integrator 4=FTP Server 5=Sterling Connect:Express 7=MQ MFT |
| ORIG_NODE | varchar | The server that initiated the Process. |
| PART_KEY | date | The date the event was generated. The format is yyyy-mm-dd. |
| PERCENT_COMPLETE | bigint | Percentage of a Sterling Connect:Direct Copy Process that is complete. |
| PROC_ID | varchar | Sterling Connect:Direct Process or Sterling Connect:Enterprise batch number. |
| PROC_NAME | varchar | Sterling Connect:Direct Process name or Sterling Connect:Enterprise batch name. |
| REMOTE_NODE | varchar | Name of the remote server that is involved in the Process or file transfer. |
| RET_CODE | varchar | Specifies a numeric code that is returned from a completed Process or file
transfer that indicates failure or success. The following are the standard return
codes: 0=Successful completion 4=Warning 8=Error 16=Unrecoverable error |
| RULE_ID | varchar | Name of the rule that is triggered by the event. |
| RULE_INSTANCE_ID | bigint | Unique identifier for rule matching instances. |
| SEQ_NUM | bigint | A number that is used to uniquely identify events that are generated at the same time. |
| SHORT_MSG | varchar | Message text that is associated with the Message ID. |
| SLC_FLAG | bigint | Internally used by IBM Sterling Control Center
Monitor for recovery purposes. When an
event is generated, it is sent to the SLC subsystem. This flag indicates whether the event
successfully sent to that subsystem. The following are possible values: 0=Event was not sent >0=Event was sent |
| SLC_ID | text | System-assigned name for each SLC window. |
| SLC_INSTANCE_ID | bigint | Unique identifier for each SLC window. |
| SLC_SOURCE_1 | text | Internal field used for SLC recovery. |
| SLC_SOURCE_2 | text | Internal field used for SLC recovery. |
| SLC_SRC_EVENT_ID | bigint | EVENT_ID of the event that triggered the SLC. |
| SOURCE_FILE | varchar | Source file name in a copy. |
| STEP_NAME | varchar | Name of the Sterling Connect:Direct Process step. |
| SUBMITTER | varchar | User ID of the Process submitter. |
| TRAP_FLAG | bigint | Internally used by IBM Sterling Control Center
Monitor for recovery purposes. When a
rule matches an event, the associated action is run. If the action includes sending an SNMP trap,
this flag updates after the SNMP trap is sent. The following are possible values: 0=No trap generated >0=Trap generated The value is set to zero if nothing was done, but is set to the Timestamp if something was done. |
| USER_DATA_1 | varchar | User metadata field 1. |
| USER_DATA_2 | varchar | User metadata field 2. |
| USER_DATA_3 | varchar | User metadata field 3. |
| USER_DATA_4 | varchar | User metadata field 4. |
| SERVER_DATA_1 | varchar | Server metadata field 1. |
| SERVER_DATA_2 | varchar | Server metadata field 2. |
| SERVER_DATA_3 | varchar | Server metadata field 3. |
| SERVER_DATA_4 | varchar | Server metadata field 4. |
| SERVER_DATA_5 | varchar | Server metadata field 5. |
| SERVER_DATA_6 | varchar | Server metadata field 6. |
| SERVER_DATA_7 | varchar | Server metadata field 7. |
| SERVER_DATA_8 | varchar | Server metadata field 8. |
| SERVER_DATA_9 | varchar | Server metadata field 9. |
| SERVER_DATA_10 | varchar | Server metadata field 10. |
| USER_OP_FLAG | bigint | Internally used by IBM Sterling Control Center
Monitor for recovery purposes. When a
rule matches an event, the associated action is run. If the action includes starting an OS command
script, this flag is updated after starting the OS command script. The following are possible
values: 0=No OS command started >0=OS command started The value is set to zero if nothing was done, but is set to the Timestamp if something was done. |
| XFER | varchar |
The value of Y indicates a completed file transfer event. The value of N appears for all other event types. |
| XML_STRING | text | An XML representation of the event. |