Configure VSAM and CICS - 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

Once it has been determined changes to on-line and/or batch VSAM files are to be captured, the VSAM LOGREPLICATE function is simple to configure. Connect CDC (SQData) requires the following modifications in a typical environment:

  1. Using IDCAMS, add the LOGSTREAMID with the LogStream name previously created and LOGREPLICATE 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
    Note: If CICS opens VSAM files in RLS mode then the LOG parameter must be also be specified and included in the ALTER in addition to the parameters above:

    LOG(NONE|UNDO|ALL)

  2. CICS Replication Logging Recovery Parameters must also be set for each VSAM file to be captured by the LOGREPLICATE function, with BACKOUTONLY as the minimum settings.
    Example:
     
    CEDA DEFINE FILE(name) GROUP(groupname)
    DSNAME(data set name)
    RECOVERY(NONE|BACKOUTONLY|ALL) 
    FWDRECOVLOG(NO|1–99)
    BACKUPTYPE(STATIC|DYNAMIC)
    RECOVERY PARAMETERS
    RECOVery : None | Backoutonly | All
    Fwdrecovlog : No | 1-99
    BAckuptype : Static | Dynamic
     
    Note: For more information see IBM's documentation on the following:
    • CICS Replication logging
    • Setting up access to VSAM datas sets for replication.
    • The CEDA DEFINE command
    • VSAM files accessed in non-RLS mode