Configure batch VSAM for capture - connect_cdc_sqdata - Latest

Connect CDC (SQData) can also capture Batch VSAM updates but with an additional prerequisite: IBM's CICS VSAM Recovery (CICS VR) Version 5.1 or later is required to replicate changes made by batch jobs outside of CICS Transaction Server.

1. Using IDCAMS, add the LOGSTREAMID with the LogStream name previously created and LOGREPLICATE and FRLOG parameters to the VSAM files Cluster specification in the ICF catalog entry for each VSAM file to be captured.
   Example:

   //STEP1 EXEC PGM=IDCAMS
       //SYSPRINT DD SYSOUT=*
       //SYSIN DD *
       ALTER SQDATA.CICS.FILEA -
       LOGSTREAMID(SQDATA.VSAMCDC.LOG1) -
       LOGREPLICATE
       FRLOG(REDO|UNDO|ALL)

   Where the value of the FRLOG parameter may not be () Null but rather one of the following:

   REDO - recoverable by forward recovery

   UNDO - recoverable by backout (minimum required value)

   ALL - recoverable by backout and forward recovery

2. In addition CICS VR must be authorized to access the specified recovery LogStream

Notes:

• CICS VR VSAM batch logging cannot perform logging for VSAM data sets that are accessed in RLS mode unless CICS is brought down or a command has been issued to deallocate the files your batch jobs need to update. For example, you can use the following CICS command CEMT SET FILE(PAYROLL) CLO ENA to disable (deallocate) PAYROLL so your batch jobs can update that file and CICS VR VSAM batch logging can log the changes:
• When LOGREPLICATE and LOGSTREAMID are specified for a VSAM Cluster, the LogStream will contain both before and after images that are normally only for Forward Recovery.
• If Forward Recovery was specified prior to the implementation of Capture then the Publisher must be instructed not to clean the LogStreams containing the data used for Replication. Please contact Precisely https://www.precisely.com/support before implementation to discuss various configuration options including the utilization of multiple CDCZlog Publisher agents. Cleaning can be disabled by specifying the keyword --ptk=8 in the Publisher startup command parameter.
• For more information see IBM's documentation on the following: Setting up CICS VR VSAM batch logging