Stopping schema-level subscriptions
You stop a schema-level subscription to instruct the Q Capture program to quit capturing SQL operations such as CREATE TABLE and DROP TABLE for tables that are part of the subscription. You can also optionally stop all of the included table-level Q subscriptions.
About this task
About this task
Stopping a schema-level subscription entails inserting a STOP SCHEMASUB signal into the IBMQREP_SIGNAL table at one or more Q Capture servers. When you use the ASNCLP program to stop schema-level subscriptions, it performs these inserts.
When Q Capture processes the signal, the state of the corresponding schema-level subscription changes to I (inactive) in the IBMQREP_SCHEMASUBS table. The state of table-level Q subscriptions remains unchanged unless you explicitly stop these subscriptions, which can be done in a single command by the ASNCLP program.
Procedure
Procedure
Method | Description |
---|---|
ASNCLP command-line program | Use the STOP SCHEMASUB command. You have two options:
|
SQL | Insert a STOP SCHEMASUB signal into the IBMQREP_SIGNAL table at one or more Q Capture
servers: Where
schema identifies a Q Capture program, and schema_subname is
the name of the schema-level subscription that you want to stop.For bidirectional or peer-to-peer replication, you must insert the signal into all Q Capture servers in the configuration. |