Sterling B2B Integrator statistics table for Sterling File Gateway (FG_STATS_LOG)
Describes the elements and element types for the properties in the FG_STATS_LOG table.
FG_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. |
| ARRIVEDFILE_KEY | varchar | Indicates the name of the file key for the arrived file. |
| COMPLETE_TIME | varchar | Step Completion Time. |
| CONS_ORG_KEY | varchar |
Sterling File GatewayConsumer Org Key. |
| CONSUMER_DOCID | varchar | Consumer’s Document ID. |
| CONSUMER_MSGID | varchar | Consumer’s Message ID. |
| CREATEPROGID | varchar | Reserved for future use. |
| CREATETS | varchar | Reserved for future use. |
| CREATEUSERID | varchar | Reserved for future use. |
| DATA_FLOW_ID | varchar | Data Flow ID. |
| DELIVCHAN_KEY | varchar | Delivery Channel Key . |
| DELIVERY_KEY | varchar | Delivery Key. |
| DELIVS_REMAIN | varchar | Number of Deliveries remaining . |
| DOCUMENT_ID | varchar | Document ID. |
| EVENT_ATTR_KEY | varchar | Reserved for future use. |
| EVENT_CODE | varchar | Sterling File Gateway Message ID. |
| EVENT_ID | bigint | Same as EVENTS.EVENT_ID. |
| EVENT_KEY | varchar | Reserved for future use. |
| FILE_NAME | varchar | Sterling File Gateway Arrived File Name. |
| LOCKID | varchar | Reserved for future use. |
| LOG_DATE_TIME | varchar | Same as EVENTS.DATE_TIME. |
| MAILBOX_PATH | varchar | Indicates the path of the mailbox. |
| MESSAGE_ID | varchar | Sterling File Gateway Message ID. |
| MODIFYPROGID | varchar | Reserved for future use. |
| MODIFYTS | varchar | Time the Sterling File Gateway was modified. |
| MODIFYUSERID | varchar | Reserved for future use. |
| NAME | varchar | Reserved for future use. |
| P_FSTRUCT_KEY | varchar | Reserved for future use. |
| PART_KEY | date | The date the event was generated. The format is yyyy-mm-dd. |
| PROD_ORG_KEY | varchar | Producer’s key. |
| REPLAY_AF_KEY | varchar | Arrived file key when the file is re-played. |
| REPLAY_COMMENT | varchar | Comment entered when the arrived file is replayed. |
| REVIEWED | varchar | Reserved for future use. |
| ROUTCHAN_KEY | varchar | Route Channel Key. |
| ROUTE_EVENT_KEY | varchar | Route Event’s key. |
| ROUTE_KEY | varchar | Route Key. |
| ROUTES_REMAIN | varchar | Number of routes remaining. |
| START_TIME | varchar | Start time of the event. |
| STATE | varchar | State of the event – Depending on the even type, it could be Completed, Routed. |
| TIME | varchar | Time stamp of the event created. |
| WFID | varchar | Workflow associated with the step, if any. |
| CONSUMER_FILENAME | varchar | Consumer’s file name. |