One or more output Datastores, also referred to as Subscriptions, may be specified for each Source table in the configuration file. Once the initial configuration file has been created, Datastores are added or removed using the SQDCONF modify command.
The following example adds a subscription for a second Target Engine DB2TOORA for changes to the SQDATA.dept table:
//*-----------------------------------------------
//*- ADD SECOND TARGET FOR A TABLE TO CONFIG FILE
//*-----------------------------------------------
//ADDTBL2 EXEC PGM=SQDCONF
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SQDPARMS DD *
modify /home/sqdata/db2cdc/db2cdc.cab
--key=<sqd.dept> --datastore=cdc:////DB2TOORA
--active
//*Note:
- A modify must be performed for each source table that will be published to the new Engine.
- The configuration file changes must be followed by an apply in order to have the capture agent recognize the updated configuration file.