Sterling B2B Integrator virtual statistics table (V_AF_STATS_LOG)

Describes the elements and element types for the properties in the V_AF_STATS_LOG table.

V_AF_STATS_LOG

Important: During the upgrade process from a release of IBM® Sterling Control Center Monitor before V5.4.2.1, tables are created to capture Sterling B2B Integrator activity. If you have data that was collected from Sterling B2B Integrator before you upgrade to IBM Sterling Control Center Monitor V5.4.2.1, or later, run the convertB2BData utility to migrate your existing data to the Sterling B2B Integrator tables. This utility migrates data that is 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 migrate your data.
Element Type Description
E.CC_NAME varchar Reserved for future use.
A.ADAPTER_DISP_NAME varchar Indicates the adapter display name.
A.ADAPTER_NAME varchar Indicates the actual adapter name.
A.ADAPTER_TYPE varchar Indicates the adapter type.
A.CHILD_SESSIONID varchar Reserved for future use.
A.CON_END_TIME varchar Indicates the time that the connection ended.
A.CON_IS_SUCCESS varchar Indicates whether the connection is successful or not.
A.CON_START_TIME varchar Indicates the time that the connection starts.
E.DATE_TIME varchar Date and time that the event was generated. Format yyyy/mm/dd hh:mm:ss.msmsms.
E.DEST_FILE varchar Destination file name in a copy operation.
A.DIS_END_TIME varchar Indicates the time that the disconnection ended.
A.DIS_IS_SUCCESS varchar Indicates whether the disconnection succeeded or not.
A.DIS_START_TIME varchar Indicates the time that the disconnection started.
A.DOC_ID varchar Indicates the document ID.
A.DOC_NAME varchar Indicates the document name.
E.FROM_NODE varchar Server that sent the file.
A.END_TIME varchar Indicates step end time.
A.END_WFSTEP varchar Indicates the ending work flow step.
A.END_WFID varchar Indicates the ending work flow ID.
A.ENDPOINT1 varchar IP address or host name of the source, or destination that is depending on IS_PUT or IS_LOCAL_INIT.
A.ENDPOINT2 varchar IP address or host name of the source, or destination that is depending on IS_PUT or IS_LOCAL_INIT.
A.ENDPORT1 varchar Port number of the source or destination that is depending on IS_PUT or IS_LOCAL_INIT.
A.ENDPORT2 varchar Port number of the source or destination that is depending on IS_PUT or IS_LOCAL_INIT.
A.ERROR_MSG varchar Error message, if there is one.
E.EVENT_ID bigint Indicates the event ID, which is the same as the EVENTS.EVENT_ID.
E.EVENT_TYPE bigint Code indicating the type of event.
E.FILE_SIZE bigint Size of the file that is transferred by the Sterling B2B Integrator batch.
A.IS_BIN_XFER varchar Indicates whether it is the binary transfer or not.
A.IS_LOCAL_INIT varchar Indicates whether the transfer was locally initiated or not.
A.IS_PUT varchar Indicates whether the transfer is a put or get.
A.IS_SECURE varchar Indicates whether the file transfer was secured.
A.IS_SUCCESS varchar Indicates whether the file transfer was successful.
A.KBYTES_XFER bigint Indicates the size, in kilobytes, of the file transfer.
A.LOG_DATE_TIME varchar Indicates the date and the time the transfer was logged. Same as the EVENTS.DATE_TIME.
A.MBOX_PATH varchar Indicates the path of the mailbox.
E.MSG_ID varchar Server message ID issued with the event.
E.NODE_ID varchar Server name alias.
E.NODE_NAME varchar Name of server.
E.NODE_TYPE varchar Code indicating the type of server. 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
E.ORIG_NODE varchar The server that initiated the process.
A.PRINCIPAL varchar User ID associated with the transfer.
E.PROC_ID varchar Sterling B2B Integrator process identifier.
E.PROC_NAME varchar Sterling B2B Integrator process name.
A.PROTOCOL varchar The protocol that is used for the file transfer.
A.PS_INSTANCE varchar Perimeter Service Instance.
A.REMOTE_FILENAME varchar Name of remote file.
E.REMOTE_NODE varchar Name of the remote server that is involved in the file transfer.
E.RET_CODE varchar Specifies a numeric code that is returned from a completed process or file transfer that indicates failure or success. The standard return codes are:
0=Successful completion
4=Warning
8=Error
16=Catastrophic error
A.SECURE_MODE varchar Indicates whether the file was transferred in secure mode.
E.SERVER_DATA_1 varchar Server metadata field 1.
E.SERVER_DATA_2 varchar Server metadata field 2.
E.SERVER_DATA_3 varchar Server metadata field 3.
E.SERVER_DATA_4 varchar Server metadata field 4.
E.SERVER_DATA_5 varchar Server metadata field 5.
E.SERVER_DATA_6 varchar Server metadata field 6.
E.SERVER_DATA_7 varchar Server metadata field 7.
E.SERVER_DATA_8 varchar Server metadata field 8.
E.SERVER_DATA_9 varchar Server metadata field 9.
E.SERVER_DATA_10 varchar Server metadata field 10.
A.SESS_ARCHIVE_ID varchar Indicates the session archive ID.
A.SESS_ID varchar Indicates the session ID.
E.SEQ_NUM bigint A number that is used to uniquely identify events that are generated at the same time.
E.SHORT_MSG varchar Message text that is associated with the Message ID.
E.SOURCE_FILE varchar Source file name in a copy.
A.START_TIME varchar Indicates the session start time.
A.START_WFID varchar Transfer starting workflow ID, if any.
A.START_WFSTEP varchar Transfer starting workflow step ID, if any.
A.STATUS_CODE varchar Indicates the status of the transfer.
E.STEP_NAME varchar Name of the Sterling B2B Integrator process step.
E.SUBMITTER varchar User ID of the process submitter.
E.USER_DATA_1 varchar User metadata field 1.
E.USER_DATA_2 varchar User metadata field 2.
E.USER_DATA_3 varchar User metadata field 3.
E.USER_DATA_4 varchar User metadata field 4.
A.WFID varchar Indicates the workflow ID name.
A.WFSTEP varchar Indicates the workflow step name.
E.XFER varchar The value of Y indicates a completed file transfer event. The value of N appears for all other event types.
E.XFER_DIRECTION varchar The direction of the file transfer. Valid values are limited to inBound, outBound.
A.XFER_ERROR_MSG varchar Transfer error message, if there is one.
A.XFER_ID varchar Indicates the transfer ID.
A.XFER_STATUS_CODE varchar Indicates the transfer status code name.
E.XML_STRING text An XML representation of the event.