Starting schema-level subscriptions
You start a schema-level subscription to instruct the Q Capture program to begin capturing SQL operations such as CREATE TABLE and DROP TABLE for tables that are part of the subscription. You can also optionally start all of the included table-level Q subscriptions.
Before you begin
About this task
About this task
Newly created schema-level subscriptions are in N (new) state and are automatically started when the Q Capture program is started or reinitialized. You might need to use this procedure if you stopped the subscription or it was stopped because of an error.
Starting a schema-level subscription entails inserting a START SCHEMASUB signal into the IBMQREP_SIGNAL table at one or more Q Capture servers. When Q Capture processes the signal, the state of the corresponding schema-level subscription changes to A (active) in the IBMQREP_SCHEMASUBS table.
When you use the ASNCLP program to start schema-level subscriptions, it performs the signal inserts. If you use SQL to perform the inserts yourself, the START SCHEMASUB signal must be inserted into the IBMQREP_SIGNAL table at all Q Capture servers in bidirectional or peer-to-peer configurations.
Procedure
Procedure
Method | Description |
---|---|
ASNCLP command-line program | Use the START SCHEMASUB command. You have two options:
|
SQL | Insert a START 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 start.For bidirectional or peer-to-peer replication, you must insert the signal into all Q Capture servers in the configuration. |