Skip to main content

Switching from initial load to continuous replication of Db2 for z/OS sources

  1. Work with your DB2 database management team to print the DB2 BSDS by executing DSNJU004 utility, as in this example:

    //DSNJU004 JOB (20,FB3),REGION=0M,         <-- Job card goes here. 
// CLASS=A,MSGCLASS=H,NOTIFY=&SYSUID 
//* 
//* 
//DSNTJU04 EXEC PGM=DSNJU004 
//STEPLIB DD DISP=SHR,DSN=DSND10.SDSNLOAD  <-- SDSNLOAD library of your DB2 subsystem 
//GROUP DD DISP=SHR,DSN=DSND10.DBDG.BSDS01 <--Boot Strap Dataset of your DB2 system 
//SYSPRINT DD SYSOUT=* 
//SYSIN DD * 
MEMBER *

    The above job should complete successfully with the return code of 0 or 4.

  2. in the BSDS Print job, find the “CHECKPOINT QUEUE” section on the report using this command:

    F “CHECKPOINT QUEUE” 28

  3. In the Checkpoint Queue section , find the “TIME OF CHECKPOINT” for the time prior to the DB2 Initial load. In this example, the initial load start time was 11:05AM on 18 September 2025, so the record of interest would be the one at 11:03:54 on 18 September 2025:

    TIME OF CHECKPOINT 11:13:43 SEPTEMBER 18, 2025
BEGIN CHECKPOINT RBA 00000000000248EEF96C
END CHECKPOINT RBA 00000000000248EF921D
END CHECKPOINT STCK 00E1821BAF9B156F6200
TIME OF CHECKPOINT 11:08:43 SEPTEMBER 18, 2025
BEGIN CHECKPOINT RBA 00000000000248EB64F2
END CHECKPOINT RBA 00000000000248EBFC0C
END CHECKPOINT STCK 00E1821A917EA4001600
TIME OF CHECKPOINT 11:03:43 SEPTEMBER 18, 2025  << - Record of Interest. 
BEGIN CHECKPOINT RBA 00000000000248E89498       << - Start RBA for CDC run.
END CHECKPOINT RBA 00000000000248E93507
END CHECKPOINT STCK 00E18219736229BB0E00
TIME OF CHECKPOINT 10:58:43 SEPTEMBER 18, 2025
BEGIN CHECKPOINT RBA 00000000000248E237B6
END CHECKPOINT RBA 00000000000248E2CB8C
END CHECKPOINT STCK 00E182185545C6605000

  4. Copy the BEGIN CHECKPOINT RBA value for the record of interest, in this case 00000000000248E89498 .

  5. Set the RBA_LRSN in the Striim Agent for Db2 for z/OS configuration filethe Striim Agent for Db2 for z/OS configuration file to the BEGIN CHECKPOINT RBA value for the record of interest,