Sterling B2B Integrator statistics table for virtual statistics (V_BP_STATS_LOG)
Describes the elements and element types for the properties in the V_BP_STATS_LOG table.
V_BP_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. |
| B.ACTIVITYINFO_ID | varchar | Internal column. |
| B.ADV_STATUS | varchar | Status of the Business Process step. |
| B.BASIC_STATUS | varchar | Status of the Business Process step. |
| 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. |
| B.END_TIME | varchar | Business process step end time. |
| 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 file that is transferred by the Sterling B2B Integrator batch. |
| E.FROM_NODE | varchar | Server that sent the file. |
| B.LOG_DATE_TIME | varchar | Indicates the date and the time the transfer was logged. Same as the EVENTS.DATE_TIME. |
| E.MSG_ID | varchar | Server message ID issued with the event. |
| B.NAME | varchar | Reserved for future use. |
| B.NEXT_AI_ID | varchar | Internal column. |
| B.NODEEXECUTED | varchar | The cluster node where the Process ran. |
| 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. |
| PART_KEY | date | The date the event was generated. The format is yyyy-mm-dd. |
| E.PROC_ID | varchar | Sterling B2B Integrator process identifier. |
| E.PROC_NAME | varchar | Sterling B2B Integrator process name. |
| 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 |
| 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. |
| B.SERVICE_NAME | varchar | Name of the service in the business process step. |
| E.SEQ_NUM | bigint | A number that is used to uniquely identify events that are generated at the same time. |
| E.SOURCE_FILE | varchar | Source file name in a copy. |
| B.START_TIME | varchar | Business process step start time. |
| E.SHORT_MSG | varchar | Message text that is associated with the Message ID. |
| B.STEP_ID | varchar | Business Process step number. |
| 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. |
| B.WFD_ID | varchar | Identifier for the Business Process Name. |
| B.WFD_NAME | varchar | Business Process Name. |
| B.WFD_VERSION | varchar | Business process version number. |
| B.WFE_STATUS | varchar | Status of the executed business process. |
| B.WORKFLOW_ID | varchar | Business process instance ID. |
| B.PROCESS_DATA | varchar | Data from Process Instance data, if collected. |
| 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. |
| E.XML_STRING | text | An XML representation of the event. |