Data movement service metadata and logging table

This section provides reference information about logging table structure in the WebSphere® Business Monitor databases. The logging tables are static tables.

RMMETADATA

A varying number of component instances are used to provide data movement services for a given business measures model. Each one of the State, Runtime, and Historical databases contains a table that lists for each business measures model the names of component instances that have been assigned, as well as other useful internal information. This table is updated each time component instances are created and configured during the deployment phase. Do not modify its contents manually.

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 Nnot 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.
Using the following simplified example view:
RMMETADATA example
It is easy to determine that source WBI.CTXTQ4MUF in the State database is being monitored by Capture component instance CAPTURE_1. Any changes to the source table are recorded in work table CAP.CD_2 and then applied by Apply component instance APPLY_4 to work table APP.CCD_6. This table is used by an ETL component instance to populate target table WBI.CTXTQ4MUF in the Runtime database.
RMLOG

The Runtime and Historical databases each contain a logging table that can be used to obtain statistics, progress, debugging, or error information. All ETL components and Target Life Cycle components write messages to this table but do not read from it. Some messages may be suppressed by setting the logging level to a minimum.

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).

Each row in this table corresponds to a message that was issued by component instance <NAME> at <ENTRYSTMP> . Rows having the same <ID> and <NAME> represent messages that have been generated during the same invocation of <NAME>. The following example contains log entries that were generated by ETL component instances WBIRMADM.WBIRMSP_10 and WBIRMADM.WBIRMSP_14 as well as Target Life Cycle component instances WBIRMADM.WBIRMSP_P13 and WBIRMADM.WBIRMSP_P_17. WBIRMADM.WBIRMSP_10 (4:40:20 PM) and WBIRMADM.WBIRMSP_14 (4:40:27 PM) issued five messages each and WBIRMADM.WBIRMSP_P_13 (4:40:20 PM) and WBIRMADM.WBIRMSP_P_17 (4:40:20 PM) one.
WBIRMADM.RMLOG example
This table is not automatically pruned. The DBA should regularly monitor and prune it. Use the information found in WBIRMADM.RMMETADATA to identify for which business measures model the component instance <NAME> provides service. Note that the value of the LOGLEVEL and ETL_0_MINUTES columns from the WBIRMADM.RMCONTROL table and the value of the LOGLEVEL and PRUNE_INTERVAL from the WBIRMADM.RMPRUNECTRL table will affect the growth rate of this table. More entries will be made when LOGLEVEL is set to 1, when ETL_0_MINUTES decreases, and when PRUNE_INTERVAL decreases.

Copyright IBM Corporation 2005, 2006. All Rights Reserved.