DUPTBL - Duplicate added table metadata
Use this command to promote table metadata from a test environment to a production environment.
This command is intended for working environments where a CDC Replication replication
configuration is first defined for tables in a test environment and
then promoted to production. Specifically, this command modifies CDC Replication publisher
metadata that refers to the specified source tables added to the catalog
in a test environment. Metadata is modified to reference the source
tables in production that correspond to the tables that have been
added to the catalog in the test environment. CDC Replication verifies
that the corresponding source tables in production exist and have
the same names and attributes as the tables in the test environment.
If CDC Replication detects
a discrepancy, the attempt to modify the metadata through this command
fails. In this case, messages are generated to inform you of the differences
that were detected.
Applies To—Source
Parameters
Source table name (TABLE)
Specifies the name of the source table that you have updated and want to make available for replication by either:- Name
- Specifies the name of a table
- generic*
- Generic names may be used for tables, by adding an asterisk (*) after one or more characters that are common to the group of table names. For example, 'abc*' specifies all tables starting with the characters 'abc'.
- *ALL
- Specifies all tables.
Library name (TOLIB)
The name of the production library containing the added source table that corresponds to the test table specified in the TABLE parameter.- Name
- The library name.
Result
Relevant messages are produced to the job log.Examples
DUPTBL TABLE(TSTPUB/*ALL)
TOLIB(PRDPUB)Publisher metadata for all added source tables in library TSTPUB is copied to library PRDPUB.
DUPTBL TABLE(TSTPUB/CUSTOMER)
TOLIB(PRDPUB)Publisher metadata for added source table CUSTOMER in library TSTPUB is copied to library PRDPUB.