Set the capture start point - 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

The IMS Log Reader Capture will by default use the "current" time as starting point. Capture can also be started or restarted at a point-in-time by explicitly specifying the starting LSN in the IMS Log Reader Capture Agent configuration (.cab) file with JCL similar to sample member SQDCONIM included in the distribution.

Syntax
sqdconf modify <cab_file_name>
--zlog=<log_stream_name>
[--lsn =<STCK.sequence_number>]
Keyword and Parameter Descriptions
Keyword Description
<cab_file_name>

Must be specified and must match the name specified in the previous create command.

--zlog=<log_stream_name>

The z/OS System LogStream created earlier.

[--lsn =<STCK.sequence_number>]

Specifies a UTC timestamp and an IMS Log Sequence Number. The timestamp is a 16 hexadecimal digit time of day UTC clock value in IBM Store Clock (STCK) format. The Sequence Number is a 1 to 16 hexadecimal digit IMS log Sequence Number. The lsn 0 or 0.0 specifies "now" which is the default when this parm is not specified.

Example
  1. Set the LSN to 0 (zero means current time) at the capture agent level for all DBD's) with the SQDCONF modify command.

    //*----------------------------------------
    //*- SET LSN AT GLOBAL LEVEL
    //*----------------------------------------
    //SETLSN EXEC PGM=SQDCONF
    //SYSPRINT DD SYSOUT=*
    //SYSOUT   DD SYSOUT=*
    //SQDPARMS DD *
    modify /home/sqdata/imscdc/imscdc.cab
    --lsn=0  
    //*
  2. Set the LSN the first IMS Log Sequence Number for a specific IBM Store Clock (STKC) value with the SQDCONF modify command.
    //*----------------------------------------
    //*- SET LSN AT GLOBAL LEVEL
    //*----------------------------------------
    //SETLSN EXEC PGM=SQDCONF
    //SYSPRINT DD SYSOUT=*
    //SYSOUT   DD SYSOUT=*
    //SQDPARMS DD *
    modify /home/sqdata/imscdc/imscdc.cab
    --lsn=d011f1b94eb3e0c0.0
    //*