This section provides reference information about logging table structure in the WebSphere® Business Monitor databases. The logging tables are static tables.
Column name | Column Type | Column Description |
---|---|---|
ID | NUMERIC | Not used |
OM_NAME | CHARACTER | The name of the associated business measures model project served by these replication artifacts. |
OM_ID | NUMERIC | Not used |
MC_NAME | CHARACTER | The name of the associated business measures group served by these replication artifacts. |
MC_ID | NUMERIC | Not used |
TGT_TAB_NAME | CHARACTER | The fully qualified name of the target table that is populated by the ETL stored procedure. |
TGT_RM_APP_SVR_NAME | CHARACTER | The name of the server responsible for running replication apply operations. |
TGT_RM_APP_SS_NAME | CHARACTER | If available, a group managed by the apply server, for DB2® SQL replication. This is a subscription set. |
TGT_RM_APP_STG_TAB_NAME | CHARACTER | The fully qualified name of the staging table used
as a target by the replication apply program. Note: There are two other tables
that have the extension _BKUP and _M that exist in the system
and are related to this row.
|
TGT_RM_APP_ERR_TAB_NAME | CHARACTER | The fully qualified name of the table that stores pointers to rows in the staging table that still need to be processed by ETL. |
TGT_RM_APP_PRUNE_SP_NAME | CHARACTER | The fully qualified name of the stored procedure responsible for pruning the apply staging table on the target system. |
TGT_RM_APP_TMP_TAB_NAME | CHARACTER | The fully qualified name of the temp table that is used by the ETL program to determine which rows should be loaded in the target table. |
TGT_RM_SPETL_NAME | CHARACTER | The fully qualified name of the ETL stored procedure that is responsible for populating the target table from the entries in the staging table. |
SRC_TAB_NAME | CHARACTER | The fully qualified name of the source table that is being replicated into the staging table. |
SRC_RM_CAP_SVR_NAME | CHARACTER | The name of the server responsible for running replication capture operations. |
SRC_RM_CAP_STG_TAB_NAME | CHARACTER | The fully qualified name of the table used by the Capture server to store changes to the source table. |
SRC_RM_PRUNE_TRG_NAME | CHARACTER | The fully qualified name of the trigger responsible for removing selected rows from the source table during the Capture server pruning cycle. Selected rows may include rows representing completed operations. |
SERVICE_NAME | CHARACTER | A label used to identify the service these artifacts belong to, for example, State_to_Runtime or Runtime_to_Historical. |
Column name | Column Type | Column Description |
---|---|---|
ENTRYSTMP | TIMESTAMP(10) | The timestamp for a particular entry in this log table. |
ID | NUMERIC | An identifier to associate multiple rows from the same instance together. This ID comes from the SEQUENCE WBIRMADM.RMSPTRIGID. |
ROWS_INSERTED | NUMERIC | An indicator of how many rows were inserted during this instance. |
ROWS_UPDATED | NUMERIC | An indicator of how many rows were updated during this instance. |
ROWS_DELETED | NUMERIC | An indicator of how many rows were deleted during this instance. |
ROWS_INERROR | NUMERIC | An indicator of how many rows were marked as causing a recoverable error during this instance. |
NAME | CHARACTER | The fully qualified name of the stored procedure, trigger, or process that caused the entry in this table. |
OPERATION | CHARACTER | A label identifying the operation that was being performed when this entry was made. |
RESULT | CHARACTER | A column where more information could be found about the operation that occurred. |
ISTRACEENTRY | NUMERIC | A column indicating whether this entry requires
LOGLEVEL (in WBIRMADM.RMCONTROL) to be set to 1. 0: This log entry is not a trace entry. 1: This log entry is a trace entry (and may be suppressed - see WBI.RMCONTROL table). |