This Dynamic System Table reflects the current settings of the CDC_BASE and CDC_TABLE Multi-User startup options as changed by console-like CDC_BASE and CDC_TABLE commands. For CDC_TABLE entries, one row exists for each database with table name that is currently set with the YES or NO values. No row exists for any database with table name that is currently set with the IGN value. The presence of a database with table name row is considered an exception to the normally expected processing done using CDC_BASE. One row also exists for each database (table name blank) that is currently set with the YES value using CDC_BASE. Table entries have priority over a database entry if both have the same DBID.
Note: Tables can exist that are not represented as rows in this table. Do not be confused by the apparent conflict of having a database set to NO where every table in the database is set to YES.
The ordering for this table includes the MUF name, the DBID, and the table name. Database entries have the table name set to blanks and are lower in order than all other table names in that database.
The MUF_CDC_BASE_TABLE contains the following columns:
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
DBID
|
SMALLINT |
No |
The database identifier (database ID). |
|
MUF_NAME
|
CHAR(8) |
No |
Name of the MUF specified in the MUF Multi-User startup option or the MUF job name. |
|
PROPAGATE |
CHAR(1) |
No |
Contains a letter Y if this entry is subject to CDC. Contains a letter N if this entry is not subject to CDC. Note: CDC_BASE databases that are currently set to NO (the default) do not have a row in this table, and therefore every present CDC_BASE entry with its blank table name always has the PROPAGATE value set to the letter Y. |
|
TABLE_NAME |
CHAR(3) |
No |
For CDC_TABLE entries, contains the table name that has been set to participate or to not participate. For CDC_BASE entries, contains blanks. |
|
Copyright © 2014 CA.
All rights reserved.
|
|