Add subscription to CDCzLog publisher - connect_cdc_sqdata - Latest

Connect CDC (SQData) Change Data Capture

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Change Data Capture
Copyright
2024
First publish date
2000
Last updated
2024-11-25
Published on
2024-11-25T15:05:48.570404

Examine the existing CDCzLog Publisher Agent configuration (.cab) file. In our example, the new Keyed File file had already been added to the capture process and the Publisher Agent but was directed to an existing Engine. The Publisher Agent configuration must now be updated to publish the captured data to the new Engine. The sqdconf utility, with with JCL similar to sample member SQDCONVP included in the distribution can be used to update the CAB file using the add command specifying the RECALIAS and the new target datastore.

Syntax
add --key=<RECALIAS>
   --datastore=cdc:///<engine_agent_alias>
   --active | --inactive
  <cab_file_name>
Example
//*----------------------------------------
//*-  ADD ENGINE TO THE CONFIG FILE
//*----------------------------------------
//ADDENG   EXEC SQDCONF,OWNER=&SYSUID
//SQDPARMS DD *  
add --key=FILEB
      --datastore=cdc:////KFITOORA
      --active
  /home/SQD/kfilepub1/KFILEPUB1.cab
A SQDCONF display job can then be run to review the complete content of the updated CAB file.
//*-----------------------------------
//*  DISPLAY CONFIG FILE            
//*-----------------------------------
//DISPLAY  EXEC SQDCONF
//SQDPARMS DD *
display /home/SQD/kfilepub1/KFILEPUB1.cab
//*