Sterling B2B Integrator statistics table for protocol activity (AFT_STATS_LOG)
Describes the elements and element types for the properties in the AFT_STATS_LOG table.
AFT_STATS_LOG
Important: During the upgrade process, IBM® Sterling Control Center
Monitor creates tables to capture Sterling B2B Integrator activity. If you have data
that was collected from Sterling B2B Integrator
prior to upgrading to IBM Sterling Control Center
Monitor
V5.4.2.1, run the convertB2BData utility to migrate your existing data to the
Sterling B2B Integrator tables. This utility
migrates data previously stored in the EVENTS table to where it is stored now in the following
tables: Sterling File Gateway activity (FG_STATS_LOG), protocol activity (AFT_STATS_LOG), and
business process activity (BP_STATS_LOG). Run the migration utility after you upgrade IBM Sterling Control Center
Monitor, while the engine is stopped.
Do not run Sterling B2B Integrator or Sterling File Gateway reports for data that was
collected before the upgrade until you have migrated your data.
| Element | Type | Description |
|---|---|---|
| CC_NAME | varchar | Reserved for future use. |
| ADAPTER_DISP_NAME | varchar | Indicates the adapter display name. |
| ADAPTER_NAME | varchar | Indicates the actual adapter name. |
| ADAPTER_TYPE | varchar | Indicates the adapter type. |
| CHILD_SESSIONID | varchar | Reserved for future use. |
| CON_END_TIME | varchar | Indicates the time the connection ended. |
| CON_IS_SUCCESS | varchar | Indicates whether the connection is successful or not. |
| CON_START_TIME | varchar | Indicates the time the connection starts. |
| DIS_END_TIME | varchar | Indicates the time the disconnection ended. |
| DIS_IS_SUCCESS | varchar | Indicates whether the disconnection succeeded or not. |
| DIS_START_TIME | varchar | Indicates the time the disconnection started. |
| DOC_ID | varchar | Indicates the document ID. |
| DOC_NAME | varchar | Indicates the document name. |
| END_TIME | varchar | Indicates step end time. |
| END_WFSTEP | varchar | Indicates the ending work flow step. |
| END_WFID | varchar | Indicates the ending work flow ID. |
| ENDPOINT1 | varchar | IP Address or Host name of the source or destination depending on IS_PUT or IS_LOCAL_INIT. |
| ENDPOINT2 | varchar | IP Address or Host name of the source or destination depending on IS_PUT or IS_LOCAL_INIT. |
| ENDPORT1 | varchar | Port number of the source or destination depending on IS_PUT or IS_LOCAL_INIT. |
| ENDPORT2 | varchar | Port number of the source or destination depending on IS_PUT or IS_LOCAL_INIT. |
| ERROR_MSG | varchar | Error message, if there is one. |
| EVENT_ID | bigint | Indicates the event ID, which is the same as the EVENTS.EVENT_ID. |
| IS_BIN_XFER | varchar | Indicates whether it is the binary transfer or not. |
| IS_LOCAL_INIT | varchar | Indicates whether the transfer was locally initiated or not. |
| IS_PUT | varchar | Indicates whether the transfer is a put or get. |
| IS_SECURE | varchar | Indicates if the file transfer was secured. |
| IS_SUCCESS | varchar | Indicates if the file transfer was successful. |
| KBYTES_XFER | bigint | Indicates the size, in kilobytes, of the file transfer. |
| LOG_DATE_TIME | varchar | Indicates the date and the time the transfer was logged. Same as the EVENTS.DATE_TIME. |
| MBOX_PATH | varchar | Indicates the path of the mailbox. |
| PART_KEY | date | The date the event was generated. The format is yyyy-mm-dd. |
| PRINCIPAL | varchar | User ID associated with the transfer. |
| PS_INSTANCE | varchar | Perimeter Service Instance. |
| REMOTE_FILENAME | varchar | Name of remote file. |
| SECURE_MODE | varchar | Indicates if the file was transferred in secure mode. |
| SESS_ARCHIVE_ID | varchar | Indicates the session archive ID. |
| SESS_ID | varchar | Indicates the session ID. |
| START_TIME | varchar | Indicates the session start time. |
| START_WFID | varchar | Transfer starting workflow ID, if any. |
| START_WFSTEP | varchar | Transfer starting workflow step ID, if any. |
| STATUS_CODE | varchar | Indicates the status of the transfer. |
| WFID | varchar | Indicates the workflow ID name. |
| WFSTEP | varchar | Indicates the workflow step name. |
| XFER_ERROR_MSG | varchar | Transfer error message, if there is one. |
| XFER_ID | varchar | Indicates the transfer ID. |
| XFER_STATUS_CODE | varchar | Indicates the transfer status code name. |