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