dmpark - Park table

Use this command to park a source table. By parking a source table, you tell CDC Replication that you do not want to capture changes for that particular table in a subscription.

When you park a table, CDC Replication does not replicate any subsequent changes you make on the source table, which may result in inconsistent source and target tables.

Note: Before you can park a source table, if you are mirroring the table to the target, then you need to end replication on the subscription. For more information, see the dmendreplication command.

Syntax

dmpark [-I <name>] -s <subscription ...> -A|-t <schema>.<table> ... 
[-L <locale>]

Parameters

[-I <name>]: Specifies the name of the CDC Replication instance. Alternatively, you can specify the TSINSTANCE environment variable in place of this value.
-s <subscription ...>: Specifies the subscription name.; To specify multiple subscriptions, list the subscriptions separated by a space.
-A: Specifies that CDC Replication parks all source tables in the subscription.
-t <schema>.<table> ...: Specifies the name of a source table in the subscription that CDC Replication parks. You must specify the table name in the format schema.table.; To specify multiple tables, list the tables separated by a space.
[-L <locale>]: The name of the locale used for the CDC Replication 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

dmpark
-I MYINSTANCE -s FINANCE -A

CDC Replication parks all source tables in the Finance subscription.