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.