1.101 LRSNTIMEDELTA

Valid For

Extract for DB2 z/OS

Description

Oracle GoldenGate extended LRSN and RBA support for DB2 z/OS. Because the data stored in DB2 increased exponentially, the LRSN and RBA value had to be increased in size from six bytes to ten bytes. The RBA value is adjusted automatically to match each log record's location in the log file. At this time DB2 z/OS has no way to adjust the LRSN timestamp value to the proper value automatically. DB2 z/OS uses a Store Clock to LRSN delta value internallly to adjust the LRSN timestamp. The Boot Strap Data Set (BSDS) utility report lists the LRSN delta. The following three lines are an excerpt from the first page of the BSDS report showing the STCK TO LRSN DELTA value.

MAX RBA FOR TORBA         00000000000000000000         
MIN RBA FOR TORBA         00000000000000000000         
STCK TO LRSN DELTA        00000053402130000000

If the STCK TO LRSN DELTA value is 00000000000000000000, then no change to the Extract parameter file is needed. If there is a value other than zero, then the Extract uses a parameter with this DELTA value to automatically adjust the log record timestamps. This is done using the LRSNTIMEDELTA parameter and it is supplied in the Extract parameter file in a format similar to the following:

TRANLOGOPTIONS LRSNTIMEDELTA 00000053402130000000

For a normal run you would specify cut and paste the 20 byte delta value from your BSDS report into the parameter file Data Sharing group. If you are not using a Data Sharing group, this value will not exist in the BSDS report.

You will see this message in the Extract report with your delta value.

2019-01-23 12:24:10  INFO    OGG-25226  The Extract is using LRSN delta value: 00000030214053000000 
This delta is used to adjust operation timestamp values.