Data for third-party reporting tools
Data for third-party reporting tools is contained in Sterling Control Center tables. The following tables are discussed here:
Note: Some fields use a Java epoch timestamp as a unique
value. This timestamp is the number of milliseconds that have elapsed
since January 1, 1970.
- Events table (EVENTS)
Sterling Control Center reports contain various data fields from the Events table. - Events extension table (EVENTS_EXT)
The Events Extension (EVENTS_EXT) database table is used when an event triggers one or more Data Visibility Group (DVG) rules. For each DVG rule an event triggers, a supplemental entry, or row, is inserted into the EVENTS_EXT table and the EVENT_ID value is used to join the information in the two tables. - Event comments table (EVENT_COMMENTS)
The Event comments table stores comment information on alerts when those alerts are deleted. In earlier versions of Sterling Control Center these comments were part of the Events table. - Sterling Connect:Direct statistics table (V_CD_STATS_LOG)
The following table describes the data fields available from the Sterling Connect:Direct® Virtual Statistics (V_CD_STATS_LOG) table for Sterling Control Center reports: - 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. - 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. - Sterling B2B Integrator statistics table for business process activity (BP_STATS_LOG)
Describes the elements and element types for the properties in the BP_STATS_LOG table. - 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. - Sterling B2B Integrator statistics table for Sterling File Gateway activity (FG_STATS_LOG)
Describes the elements and element types for the properties in the FG_STATS_LOG table. - 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. - Sterling Connect:Direct statistics table by record ID
The following table shows the columns that are filled in for each Record ID in the Virtual Sterling Connect:Direct Statistics Table (V_CD_STATS_LOG). These record IDs are for Sterling Connect:Direct for z/OS® only. - Sterling Connect:Enterprise statistics table (V_CE_STATS_LOG)
The following table describes the data fields available from the Sterling Connect:Enterprise® Virtual Statistics (V_CE_STATS_LOG) table for Sterling Control Center reports: - Sterling Connect:Express virtual statistics table (V_CX_STATS_LOG)
The following table describes the data fields available from the Sterling Connect:Express Virtual Statistics (V_CX_STATS_LOG) table for Sterling Control Center reports: - QuickFile statistics table (QF_STATS_LOG)
The following table describes the data fields available from the QuickFile statistics table (QF_STATS_LOG) for Sterling Control Center reports: - QuickFile virtual statistics table (V_QF_STATS_LOG)
The following table describes the data fields available from the QuickFile Virtual Statistics (V_QF_STATS_LOG) table for Sterling Control Center reports: - MQ MFT Statistics Table (MQ_STATS_LOG)
The following table describes the data fields available from the MQ MFT statistics table (MQ_STATS_LOG) for Sterling Control Center reports: - MQ MFT virtual statistics table (V_MQ_STATS_LOG)
The following table describes the data fields available from the MQ MFT Virtual Statistics (V_MQ_STATS_LOG) table for Sterling Control Center reports: - Event type table (EVENT_TYPE)
The Event Type table contains a listing of Sterling Control Center event types and descriptions. - Node type table (NODE_TYPE)
The Node Type table contains a listing of node (server) types monitored by Sterling Control Center. - Node discovery pair connections table (PAIR_CONN)
The following table describes the data fields available from the Node Discovery Pair Connections Table for Sterling Control Center reports. - Discovery node table (DISCOVERY_NODE)
The following table describes the data fields in the Discovery Node Table. - Metadata labels table (META_DATA_LABELS)
The following table describes the data fields available from the META_DATA_LABELS database table for reports. It holds the user-provided labels for the metadata fields. - Sterling Control Center internal tables
The following tables are used internally by Sterling Control Center. They are not available for third-party reporting.
Parent topic: Event type descriptions
Related concepts: