Data movement service control table

This section describes the Data Movement Services control table structure. Each one of the State, Runtime, and Historical databases contain two control tables that can be manipulated to configure the behavior of the local data-control movement service components. The control tables are static tables.

RMCONTROL

Contains configuration settings specific to the behavior of ETL component instances. This table is only populated and used in the Runtime and Historical databases, because no ETL component is required in the State database. Each row in this table corresponds to one target table that needs to be populated. Altering column values for a given row will only affect the ETL component instance that has been assigned to populate that target table.

Column name Column Type Column Description Nullable
TARGETTABLE CHARACTER The fully qualified table name of the target table that is to be populated by the stored procedure controlled by this entry. N
COMMITINTERVAL NUMERIC The commit interval used by the stored procedure when a cursor is used to insert rows into the target table. Y
LOGLEVEL NUMERIC The logging level that determines how much information a stored procedure will put in the WBIRMADM.RMLOG table. Valid values are 0 and 1. 0 equals minimal logging, and 1 equals maximum logging. Y
LASTSEQUENCE CHARACTER The last SEQUENCE value processed by the ETL stored procedure from the staging table. This column is updated by the stored procedure at runtime. N
LASTUPDATED TIMESTAMP The last time a scheduled invocation was made. This column is controlled by the stored procedure and is only used for scheduling purposes. Y
NEXTSTARTTIME TIMESTAMP The next time after which an ETL invocation will be made. Y
ETLSCHEDMETHOD . NUMERIC The scheduling method to be used. Only 0 is a valid value. Y
ETL_0_MINUTES NUMERIC The number of minutes that should elapse between scheduled ETL runs. Y
TGT_RM_SPETL_NAME CHARACTER The fully qualified stored procedure name that is responsible for populating the TARGETTABLE. Y
Do not alter any of the following column values or unexpected behavior will occur:
  • TARGETTABLE
  • LASTSEQUENCE
  • LASTUPDATED
  • ETLSCHEDMETHOD
  • TGT_RM_SPETL_NAME
Changes to the following columns will be committed the next time an ETL component instance is invoked:
  • COMMITINTERVAL
  • NEXTSTARTTIME
  • LOGLEVEL
  • ETL_0_MINUTES
RMPRUNECTRL

Contains configuration settings specific to the behavior of the Life Cycle component instances. This table is populated and used in the State, Runtime, and Historical databases. Each row in this table corresponds to one (source or work) table <TABLE_NAME> that requires pruning. Altering column values for a given row only affects the Life Cycle component instance that has been assigned to prune table <TABLE_NAME>.

Column name Column Type Column Description Nullable
TABLE_NAME . CHARACTER The fully qualified name of the table that is to be pruned. N
LAST_PRUNED TIMESTMP The time of the last pruning operation on this table. Y
LOGLEVEL NUMERIC The logging level that determines how much information will be put in the WBIRMADM.RMLOG table. Valid values are 0 and 1. 0 equals minimal logging; 1 equals maximum logging. N
PRUNE_ENABLED NUMERIC A flag that determines whether pruning operations should occur. 0 indicates no, and 1 indicates yes. N
PRUNE_INTERVAL NUMERIC The minimum amount of time in minutes between pruning operations. N
RETENTION_IN_MINUTES NUMERIC The length of time in minutes after which an eligible row can be pruned. N
ROWS_PRUNED NUMERIC The number of rows that were pruned during the last pruning operation. N
Do not alter any of the following column values or unexpected behavior will occur:
  • LAST_PRUNED
  • ROWS_PRUNED
  • TABLE_NAME
Changes to the following columns will be committed the next time an ETL component instance is invoked:
  • LOGLEVEL
  • PRUNE_ENABLED
  • PRUNE_INTERVAL
  • RETENTION_IN_MINUTES
Related concepts
Historical database schema
Related reference
Historical database schema
Data movement service metadata and logging table

Copyright IBM Corporation 2005. All Rights Reserved.