dmsetreplicationmethod: Set replication method

Universal Cache User Guide : IBM InfoSphere CDC for solidDB® reference : Managing tables for replication commands : dmsetreplicationmethod: Set replication method

Use this command to change the replication method for tables in a subscription. When running this command, IBM InfoSphere CDC changes the status of any Active tables to Refresh.

Note Before you run this command, you must end replication on the subscription.

Syntax

dmsetreplicationmethod -I <instance_name> <-r|-m> -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.

-m

Specifies that tables will use Mirror (Change Data Capture) as the replication method.

-r

Specifies that tables will use Refresh (Snapshot) as the replication method.

-s <subscription_names>

Specifies the name of the subscriptions.

-A

Specifies that all tables in the subscription will use the indicated replication method.

-t <schema>.<table>

Specifies the name of a source table in the subscription that will use the indicated replication method. 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

dmsetreplicationmethod -I myinstance -r -s Finance -A

All tables in the Finance subscription will use Refresh as the replication method in the specified IBM InfoSphere CDC instance.

dmsetreplicationmethod -I new_instance -m -s Finance -t acct.taxcodes

The source table acct.taxcodes in the Finance subscription will use Mirror as the replication method in the specified IBM InfoSphere CDC instance.