READDTBL - Update definition of source tables

Use this command when you have changed the definition of a source table after the table has been added to the CDC Replication metadata tables.

These changes can include adding new columns, or modifying the column name, type, or length. This command modifies the source table definition stored within CDC Replication.

CAUTION:

This command disables mirroring for all subscription that use mirroring as the mode of replication. Before issuing this command, you should perform a refresh on the subscription to ensure that the source and target tables are synchronized.

Applies To—Source

Parameters

Table 1. Supported keywords
Keyword	Description	Choices	Notes
TABLE	Source table name	`Name`	Required
LIB	Library name	`Name`	Optional
ACTIVE	Table status	NO, YES	Optional

Source table name (TABLE)

Specifies the name of the source table that you have updated and want to make available for replication by either:

Adding it to CDC Replication metadata (using the command line).
Adding it to the source tables area in Management Console (using the Management Console GUI).

Name: Specifies the name of a table

Library name (LIB)

The name of the library in which the updated source table resides.

Name: The library name.

Table status (ACTIVE)

Use this parameter to set the table's status to active.

*NO: The table is placed in Parked status after it has been made available for replication.; This is the default setting.
*YES: The table is placed in Active status after it has been made available for replication.

Result

CDC Replication adds the source table to the metadata table. If you are using Management Console, you should see the table in the Source Tables area. Also, when you issue this command, you should see relevant messages in the Event Log.

Examples

READDTBL TABLE(MYSRCTABLE)
LIB(MYLIB) ACTIVE(*YES)

Changes the definition of MYSRCTABLE which resides in MYLIB and sets the status to active.