Sterling B2B Integrator statistics table for virtual statistics for Sterling File Gateway (V_FG_STATS_LOG)

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

V_FG_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.
E.ACTION_ID varchar Name of an action that is called by a rule.
E.ACTIONS_COMPLETED bigint Indicates whether the IBM Sterling Control Center Monitor actions are completed. The values:

Null=Actions not completed

Timestamp=Actions completed

This element is used for restarts.
E.ALERT varchar Indicates whether an alert was triggered. The values:

Null=No alert

0-3=Alert severity
S.ARRIVEDFILE_KEY varchar Indicates the name of the file key for the arrived file.
S.COMPLETE_TIME varchar Step Completion Time.
S.CONS_ORG_KEY varchar

Sterling File GatewayConsumer Org Key.
S.CONSUMER_DOCID varchar Consumer’s Document ID.
S.CONSUMER_MSGID varchar Consumer’s Message ID.
S.CREATEPROGID varchar Reserved for future use.
S.CREATETS varchar Reserved for future use.
S.CREATEUSERID varchar Reserved for future use.
S.DATA_FLOW_ID varchar Data Flow ID.
E.DATE_TIME varchar Date and time that the event was generated. Format yyyy/mm/dd hh:mm:ss.msmsms.
S.DELIVCHAN_KEY varchar Delivery Channel Key.
S.DELIVERY_KEY varchar Delivery Key.
S.DELIVS_REMAIN varchar Number of Deliveries remaining.
E.DEST_FILE varchar Destination file name in a copy operation.
S.DOCUMENT_ID varchar Document ID.
E.EMAIL_FLAG bigint This field is used by IBM Sterling Control Center Monitor for recovery purposes. When a rule matches an event, the associated action is run. If the action includes sending an email, this flag updates after the email is sent. Reporting on this field is not recommended. The values:

0=No email sent

>0=email sent

The value is set to zero if nothing was done, but is set to the Timestamp if something was done.
S.EVENT_ATTR_KEY varchar Reserved for future use.
S.EVENT_CODE varchar Sterling File Gateway Message ID.
E.EVENT_ID bigint Same as EVENTS.EVENT_ID.
E.EVENT_KEY varchar Reserved for future use.
E.EVENT_TYPE bigint Code indicating the type of event.
E.FILE_NAME varchar Sterling File Gateway Arrived File Name.
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.
S.LOG_DATE_TIME varchar Same as EVENTS.DATE_TIME.
S.MAILBOX_PATH varchar Indicates the path of the mailbox.
S.MESSAGE_ID varchar Sterling File Gateway Message ID.
S.MODIFYPROGID varchar Reserved for future use.
S.MODIFYTS varchar Time the Sterling File Gateway was modified.
S.MODIFYUSERID varchar Reserved for future use.
E.MSG_ID varchar Server message ID issued with the event.
S.NAME varchar Reserved for future use.
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.
S.P_FSTRUCT_KEY varchar Reserved for future use.
E.PART_KEY date The date the event was generated. The format is yyyy-mm-dd.
E.PERCENTAGE_COMPLETE bigint Percentage of a Sterling B2B Integrator process that is complete.
E.PROC_ID varchar Sterling B2B Integrator process identifier.
E.PROC_NAME varchar Sterling B2B Integrator process name.
S.PROD_ORG_KEY varchar Producer’s key.
E.REMOTE_NODE varchar Name of the remote server that is involved in the file transfer.
S.REPLAY_AF_KEY varchar Arrived file key when the file is replayed.
S.REPLAY_COMMENT varchar Comment entered when the arrived file is replayed.
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:
0=Successful completion
4=Warning
8=Error
16=Catastrophic error
S.REVIEWED varchar Reserved for future use.
S.ROUTCHAN_KEY varchar Route Channel Key.
S.ROUTE_EVENT_KEY varchar Route Event’s key.
S.ROUTE_KEY varchar Route Key.
S.ROUTES_REMAIN varchar Number of routes that are remaining.
E.RULE_ID varchar Name of the rule that is triggered by the event.
E.RULE_INSTANCE_ID bigint Unique identifier for the rule that is matching instances.
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.
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.SLC_FLAG bigint Internally used by IBM Sterling Control Center Monitor for recovery purposes. When an event is generated, it is sent to the SLC subsystem. This flag indicates whether the event successfully sent to that subsystem. Reporting on this field is not recommended. The values:

0=Event was not sent

>0=Event was sent
E.SLC_ID text System-assigned name for each SLC window.
E.SLC_INSTANCE_ID bigint Unique identifier for each SLC window.
E.SLC_SOURCE_1 text Internal field that is used for SLC recovery.
E.SLC_SOURCE_2 text Internal field that is used for SLC recovery.
E.SLC_SRC_EVENT_ID bigint EVENT_ID of the event that triggered the SLC.
     
E.SOURCE_FILE varchar Source file name in a copy.
S.START_TIME varchar Start time of the event.
S.STATE varchar State of the event – Depending on the even type, it can be Completed or Routed.
E.STEP_NAME varchar Name of the Sterling B2B Integrator process step.
E.SUBMITTER varchar User ID of the process submitter.
S.TIME varchar Time stamp of the event created.
E.TRAP_FLAG bigint Internally used by IBM Sterling Control Center Monitor for recovery purposes. When a rule matches an event, the associated action is run. If the action includes sending an SNMP trap, this flag updates after the SNMP trap is sent. Reporting on this field is not recommended. The values:

0=No trap generated

>0=Trap generated

The value is set to zero if nothing was done, but is set to the Timestamp if something was done.
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.
E.USER_OP_FLAG bigint Internally used by IBM Sterling Control Center Monitor for recovery purposes. When a rule matches an event, the associated action is run. If the action includes starting an OS command script, this flag is updated after the OS command script starts. Reporting on this field is not recommended. The values:

0=No OS command started

>0=OS command started

The value is set to zero if nothing was done, but is set to the Timestamp if something was done.
S.WFID varchar Workflow that is associated with the step, if any.
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.
S.CONSUMER_FILENAME varchar Consumer’s file name.