dmreaddtable: Update source table definition

Universal Cache User Guide : IBM InfoSphere CDC for solidDB® reference : Managing tables for replication commands : dmreaddtable: Update source table definition

Use this command to update the definition of a source table in IBM InfoSphere CDC metadata. Run this command after you have changed the definition of a source table using your RDBMS.

Syntax

dmreaddtable -I <instance_name> <-A|-t <schema>.<table> ...> [-a] [-L <locale>]

Parameters

-I <instance_name>

Specifies the name of the IBM InfoSphere CDC instance. Alternatively, you can specify the TSINSTANCE environment variable in place of this value.

-A

Specifies that IBM InfoSphere CDC updates definitions for all source tables that are available for replication.

-t <schema>.<table>

Specifies the name of a source table in the subscription for which IBM InfoSphere CDC updates the definition. You must specify the table name in the format schema.table. List the tables if you want to specify more than one.

-a

Specifies that the active state of a table is kept after the table definition is updated.

-L <locale>

The name of the locale used for the IBM InfoSphere CDC instance. The default is your machine’s locale.

Result

This command returns a value of 0 if the command was successful and a non-zero value if the command fails.

Examples

dmreaddtable -I new_instance -A

IBM InfoSphere CDC updates definitions for all source tables that are available for replication.