Alter Extract To A Timestamp Isn't Working Correctly For GoldenGate For DB2/zOS 220.127.116.11.5
Last updated on APRIL 12, 2017
Applies to:Oracle GoldenGate - Version 18.104.22.168.5 and later
Information in this document applies to any platform.
When we stop the Z/OS extract and alter back to a timestamp (example....alter extractname BEGIN 2016-01-10 08:00:00") and restart it, it appears to be running except that the checkpoint RBA doesn't appear correct. If you execute a "send extractname status" command the read checkpoint it moving but the extract isn't capturing any operations.
If we delete and re-add the extract wiht the same timestamp, it's able to locate the correct spot in the log, the LSN that gets updated appears in the correct format and the extract captures operations as expected.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms