Use this command to stop an instance of IBM InfoSphere CDC and end replication on all subscriptions that use the instance as a source. This command is often used prior to taking a server or database offline for maintenance purposes or upgrading IBM InfoSphere CDC.
Note As a best practice before you run this command and to ensure that it completes successfully, use the dmendreplication command to end replication on all subscriptions that use the specified instance as a source and as a target. This command will not complete successfully if target subscriptions are still running.
To end replication on subscriptions that use the specified instance as a target, you can use the –a parameter which will generate an error when forcefully ending replication on subscriptions that use the specified instance as the target.
If this command does not end IBM InfoSphere CDC processes and stop the specified instance, use the dmterminate command on the UNIX and Linux platforms to force a complete shut down. On Windows platforms, use the dmterminate command to stop the service.
Specifies the name of the IBM InfoSphere CDC instance. Alternatively, you can specify the TSINSTANCE environment variable in place of this value.
-c
Specifies that IBM InfoSphere CDC stops the specified instance and ends replication on all subscriptions that use the instance as a source with the Normal option. IBM InfoSphere CDC will use this option by default if you do not specify –se, -i, or –a.
This option completes in progress work and then ends replication. If a refresh is in progress, Normal will complete the refresh for the current table before replication ends.
Normal is the most appropriate option for most business requirements and is the preferred method for ending replication in most situations.
-i
Specifies that IBM InfoSphere CDC stops the specified instance and ends replication on all subscriptions that use the instance as a source with the Immediate option.
This option stops all in progress work and then ends replication. Starting replication after using this option can be slower than using -c. If a refresh is in progress, the refresh for the current table will be interrupted and then replication will end.
Use this option if business reasons require replication to end faster than -c at the expense of a slower start when you resume replication on the specified subscriptions.
-a
Specifies that IBM InfoSphere CDC stops the specified instance and ends replication on all subscriptions that use the instance as a source or target with the Abort option. Subscriptions that use the specified instance as a target will end replication with an error.
This option stops all in progress work and then ends replication rapidly. Starting replication after using this option can be much slower than using -c. A refresh in progress will be interrupted and the target will stop processing any data that has not been committed before replication ends.
Use this option if your business reasons require a rapid end to replication and you are willing to tolerate a much slower start when you resume replication on the specified subscriptions.
A sudden business requirement for an unplanned shutdown of your source system may require this option for ending replication.
As a best practice, use the dmendreplication command to end replication on all subscriptions that use the instance specified in this command as a source or target.
-se
Specifies that IBM InfoSphere CDC will stop the specified instance and end replication normally at the current source system time in the source database log with the Scheduled End option. Replication will end on subscriptions that use the specified instance as a source. The source system time when replication will end is set when you issue this command.
As latency between the source and target increases, the amount of time required to end replication will also increase.
-t <date and time>
Indicates the date and time in the source database log when replication will end when using –se.
When specifying a value for this parameter, use the following format:
“yyyy-MM-dd HH:mm”
This parameter is optional when you specify –se.
-L <locale>
The name of the locale used for the IBM InfoSphere CDC instance. The default is the locale of the machine where IBM InfoSphere CDC is installed.
Result
This command returns a value of 0 if the command was successful and a non-zero value if the command fails.