dmreassigntable: Update target table definition

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

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

Syntax

dmreassigntable -I <instance_name> -s <subscription_names>
<-A|-t <schema>.<table> ...> [-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.

-s <subscription_names>

Specifies the IBM InfoSphere CDC subscription that contains the table. List the subscriptions if you specify more than one.

-A

Specifies that IBM InfoSphere CDC updates definitions for all target tables in the subscription.

-t <schema>.<table>

Specifies the name of a target 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 specify more than one.

-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

dmreassigntable -I new_instance -s Finance -A

IBM InfoSphere CDC updates definitions for all target tables in the Finance subscription.