Reconfigure CDCzLog publisher agent - 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 edition
2024-09-05
Last publish date
2024-09-05T15:00:09.754973
Next, examine the existing CDCzLog Publisher Agent configuration (.cab) file. Both the changes themselves and the implementation or activation of the changes must be considered. In our example, changes to a new Keyed file will be captured. The Publisher Agent must be similarly updated to manage the new captured data in the LogStream using the SQDCONF utility and add command:
add --active | --inactive --key=<RECALIAS>
  --datastore=cdc:///<engine_agent_alias>
  <cab_file_name>
The sqdconf utility, 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 new RECALIAS and the target datastore:
//*---------------------------------------------------
//*  Publish File FILEB to Subscription KFITOKFI
//*---------------------------------------------------
//ADD2     EXEC SQDCONF                
//SQDPARMS DD *                                      
add --key=FILEB
     --datastore=cdc:////KFITOKFI
    --active                                        
    /home/SQD/kfilepub1/KFILEPUB1.cab