Sterling Connect:Enterprise statistics table (V_CE_STATS_LOG)
The following table describes the data fields available from the Sterling Connect:Enterprise® Virtual Statistics (V_CE_STATS_LOG) table for IBM® Sterling Control Center Monitor reports:
| Element | Type | Description |
|---|---|---|
| APPL_AGENT_TYPE | varchar | Specifies one of the following application agent types:
|
| BATCH_ID | varchar | User-assigned description of a Sterling Connect:Enterprise batch. Note: This
column is not populated in this table since it is duplicated in the
Events table.
|
| BATCH_NUMBER | varchar | System-assigned number for each batch in a Sterling Connect:Enterprise repository. Note: This
column is not populated in this table since it is duplicated in the
Events table.
|
| BYTES_READ | bigint | Number of bytes read from the source file. |
| BYTES_WRITTEN | bigint | Number of bytes written to the destination file. |
| CC_NAME | varchar | Empty. |
| DEST_FILE | varchar | Destination file name. Note: This column is not
populated in this table since it is duplicated in the Events table.
|
| EVENT_ID | bigint | ID number that is assigned by the system to each event. |
| JOB_ID | varchar | Batch job identifier. |
| JOB_NAME | varchar | Name of the job that added the batch. |
| LINE_NAME | varchar | Line that is accessed during Auto and Remote Connects. |
| LIST_NAME | varchar | Sterling Connect:Enterprise Auto Connect List Name. The Auto Connect List defines the remote sites that the Sterling Connect:Enterprise server automatically connects to and transmits batches to. |
| LOG_DATE_TIME | varchar | Date and time that the statistics record was written to the log file. Format yyyy/mm/dd hh:mm:ss.msmsms. |
| MAILBOX_FLAGS | varchar | Sterling Connect:Enterprise batch status flag. See the appropriate Sterling Connect:Enterprise documentation for a list of batch status flags. |
| MAILBOX_ID | varchar | Specifies the repository that is associated with the Sterling Connect:Enterprise batch. |
| MSG_ID | varchar | Server or IBM Sterling Control Center
Monitor message
ID issued with the event. Note: This column is not populated in this
table since it is duplicated in the Events table.
|
| MSG_SHORT_TXT | varchar | Message short text. Note: This column is not populated
in this table since it is duplicated in the Events table.
|
| NODE_ID | varchar | Server alias. Note: This column is not populated
in this table since it is duplicated in the Events table.
|
| NODE_NAME | varchar | Name of the Sterling Connect:Direct® server. |
| NODE_TYPE | varchar | Code indicating the type of server. Note: This
column is not populated in this table since it is duplicated in the
Events table.
|
| OID | varchar | Object identifier that identifies the Sterling Connect:EnterpriseSNMP trap received by the engine. |
| PROTOCOL | varchar | Protocol that is used for the file
transfer. 1 = TCPIP Offline commands + API
2 = ASYNC Async 3 = FTP FTP 4 = BSC Bisync 6 = FTPS Secure FTP 7 = HTTP AS2 HTTP 8 = EDIINT AS2 EDI 9 = GIS GIS BP 10 = SSH SSH |
| RECIP_MAILBOX_ID | varchar | Sterling Connect:Enterprise Mailbox ID of the repository that received the batch. |
| RECORD_CATEGORY | varchar | One of the following connection types: AC=Auto Connect RC=Remote Connect |
| RECORD_ID | varchar | Type of statistics record generated. See the Event Type Descriptions Help topic for a list of record IDs. |
| REL_SELECT_STMT | varchar | Position of the Sterling Connect:Enterprise SELECT statement that ran the rule that caused an SNMP trap to be generated. |
| REMOTE_NAME | varchar | Name of the remote server that is involved in the file transfer. |
| RULE_MEMBER_NAME | varchar | Data set member name that contains the application agent rules. |
| RULE_NAME | varchar | Name of the Sterling Connect:Enterprise application agent rule. |
| SEQ_NUM | bigint | System-assigned sequence number. Note: This column
is not populated in this table since it is duplicated in the Events
table.
|
| SESSION_ID | varchar | System-assigned ID identifying a connection between a Sterling Connect:Enterprise host and a remote site. |
| SRC_FILE | varchar | Source file name. Note: This column is not populated
in this table since it is duplicated in the Events table.
|
| START_TIME | varchar | Time that start-of-batch transmission information is received by the IBM Sterling Control Center Monitor engine. |
| STATUS | varchar | FTP session status (active or inactive). Note: This
column is not populated in this table since it is duplicated in the
Events table.
|
| STOP_TIME | varchar | Time that end-of-batch transmission information is received by the IBM Sterling Control Center Monitor engine. |
| TIME_UP | varchar | Run time length of the Sterling Connect:Enterprise server. |
| USER_DATA_1 | varchar | Metadata field 1. Note: This column is not populated
in this table since it is duplicated in the Events table.
|
| USER_DATA_2 | varchar | Metadata field 2. Note: This column is not populated
in this table since it is duplicated in the Events table.
|
| USER_DATA_3 | varchar | Metadata field 3. Note: This column is not populated
in this table since it is duplicated in the Events table.
|
| USER_DATA_4 | varchar | Metadata field 4. Note: This column is not populated
in this table since it is duplicated in the Events table.
|
| WKFLOW_ID | varchar | Sterling B2B Integrator ID, if Sterling B2B Integrator requested a file transfer from a Sterling Connect:Enterprise for UNIX server. |
| WRKFLOW_URL | varchar | Sterling B2B Integrator URL, if Sterling B2B Integrator requested a file transfer from a Sterling Connect:Enterprise for UNIX server. |
| XFER | varchar |
The value of Y indicates a completed file transfer event. The value of N appears for all other event types. |