Q Replication and Event Publishing Q Replication and Event PublishingThe ASNCLP commands for multidirectional replication define, change, and drop the objects that are unique to bidirectional and peer-to-peer Q Replication.
The following topics demonstrate how you can combine multidirectional Q Replication commands to create ASNCLP setup scripts:
Table 1 lists the ASNCLP commands for Event Publishing and links to topics that describe each command.
| Description | Command |
|---|---|
| Deprecated commands | SET SERVER command (multidirectional Q Replication) |
| Change a Q subscription for bidirectional replication | ALTER QSUB command (bidirectional replication) |
| Change a Q subscription for peer-to-peer replication | ALTER QSUB command (peer-to-peer replication) |
| Change a replication queue map | ALTER REPLQMAP command |
| Establish a session for Q Replication | ASNCLP SESSION SET TO command |
| Create the control tables for the Q Capture and Q Apply programs | CREATE CONTROL TABLES FOR command |
| Create a Q subscription for bidirectional replication | CREATE QSUB command (bidirectional replication) |
| Create a Q subscription for peer-to-peer replication | CREATE QSUB command (peer-to-peer replication) |
| Create a schema-level subscription | CREATE SCHEMASUB command |
| Create a profile for table-level Q subscriptions | CREATE SUBSCRIPTION OPTIONS command |
| Create a replication queue map | CREATE REPLQMAP command |
| Drop the control tables for the Q Capture and Q Apply programs | DROP CONTROL TABLES ON command |
| Delete a replication queue map | DROP REPLQMAP command |
| Delete a schema-level subscription | DROP SCHEMASUB command |
| Delete a profile for table-level Q subscriptions | DROP SUBSCRIPTION OPTIONS command |
| Delete the subgroup that you set by using the SET SUBGROUP command. | DROP SUBGROUP command (multidirectional Q Replication) |
| Delete a Q subscription for bidirectional replication | DROP SUBTYPE command (bidirectional replication) |
| Delete a Q subscription for peer-to-peer replication between two servers | DROP SUBTYPE command (peer-to-peer replication) |
| List Q Apply schemas | LIST APPLY SCHEMA command |
| List Q Capture schemas | LIST CAPTURE SCHEMA command |
| List schema-level subscriptions | LIST SCHEMASUB command |
| Signal that a manual load of the target table is complete | LOAD DONE command |
| Promote Q subscriptions | PROMOTE Q SUB command (multidirectional replication) |
| Promote replication queue maps | PROMOTE REPLQMAP command |
| Reinitialize a schema-level subscription | REINIT SCHEMASUB command |
| Set the Q Apply schema for all task commands | SET APPLY SCHEMA command |
| Set the Q Capture schema for all task commands | SET CAPTURE SCHEMA command |
| Connect the servers that are used for bidirectional or peer-to-peer replication. | SET CONNECTION command (multidirectional Q Replication) |
| Specify whether the ASNCLP will enforce matching constraints between the source and target tables. | SET ENFORCE MATCHING CONSTRAINTS command (multidirectional Q Replication) |
| Define the log file for the ASNCLP program | SET LOG command |
| Define output files that contain SQL scripts for multidirectional replication | SET OUTPUT command (multidirectional Q Replication) |
| Specify custom parameters for database objects to be created implicitly | SET PROFILE command |
| Set the WebSphere MQ queue manager | SET QMANAGER command |
| Set a reference table to identify a Q subscription that you want to change or delete. | SET REFERENCE TABLE command (multidirectional Q Replication) |
| Specify the name of the subgroup, a collection of Q subscriptions between servers that are used for multidirectional replication | SET SUBGROUP command (multidirectional Q Replication) |
| Specify the tables that participate in a bidirectional or peer-to-peer configuration | SET TABLES command (multidirectional Q Replication) |
| Enable and disable the trace for the ASNCLP commands | SET TRACE command |
| Display the environment set during the session | SHOW SET ENV command |
| Start a Q subscription | START QSUB command |
| Start a schema-level subscription | START SCHEMASUB command |
| Stop a Q subscription | STOP QSUB command |
| Stop a schema-level subscription | STOP SCHEMASUB command |
| Verify that the required WebSphere MQ objects exist and have the correct properties for schemas, queue maps, and Q subscriptions. | VALIDATE WSMQ ENVIRONMENT FOR command |
| Send test messages that validate the message flow between the WebSphere MQ queues that are specified for a replication queue map. | VALIDATE WSMQ MESSAGE FLOW FOR REPLQMAP command |
