Db2 Version 12 requires that your databases be upgraded to use a 10 Byte Log Sequence Number (LSN). While that task falls into the domain of the Db2 Database Administrator, the Connect CDC (SQData) Db2/z Change Data Capture requires the following steps to be performed at the time the LSN length is changed:
- Find the RBA that you want to start from in the DB2 MSTR address space, once the migration to NFM (new-function mode) is complete. Look for the following messages from the Db2 recovery manager in the system log that indicate the progress of Db2 through a restart process. You are looking for the RBA from the prior checkpoint. You may need the assistance of the Db2 DBA assigned to the migration of a System operator.
DSNR001I -DBBG RESTART INITIATED DSNR003I -DBBG RESTART...PRIOR CHECKPOINT RBA=000000000000CFB28090 - With the capture down completely, run the following JCL to set the global LSN and target engine LSN, using the RBA the value identified in step 1.
//*---------------------------------------------- //*- Modify DB2 Capture CAB File Global LSN/RBA //*---------------------------------------------- //STOP EXEC PGM=SQDCONF //SYSPRINT DD SYSOUT=* //SYSOUT DD SYSOUT=* //SQDPARMS DD * modify --lsn=000000000000CFB28090 /home/sqdata/db2cdc/db2cdc.cab /* //* //*---------------------------------------------- //*- Modify DB2 Capture CAB File Target LSN/RBA //*---------------------------------------------- //STOP EXEC PGM=SQDCONF //SYSPRINT DD SYSOUT=* //SYSOUT DD SYSOUT=* //SQDPARMS DD * modify --lsn=000000000000CFB28090 --target=cdc:////DB2REPL1 --datastore=cdc:////DB2TODB2 /home/sqdata/db2cdc/db2cdc.cab //* - In the capture startup parm, modify the safe restart point. Note: You will need to remove the --safe-restart after the capture has been started and is running because you do not want it used again accidentally following another restart of the Capture
--apply --start --safe-restart=000000000000CFB28090 /home/sqdata/db2cdc/db2cdc.cab