Issue With DB2 Upgrade After OGG 12.2 Upgrade From OGG 12.1 ( OGG-06602 Journal Sequence Number out of order in single journal extract.)
(Doc ID 2595332.1)
Last updated on OCTOBER 03, 2019
Applies to:Oracle GoldenGate - Version 220.127.116.11.2 and later
Information in this document applies to any platform.
OGG for IBM z/OS on System z upgraded to GG12.2 from OGG 12.1 caused below issue while alter the process with system sequence numbers :
alter extract EI8SQPPB seqno 1 JOURNAL PB/QSQJRN JRNRCV PB/QSQJRN8838 ==<<<<<
2019-08-08 21:28:36 ERROR OGG-06602 Journal Sequence Number out of order in single journal extract.
Journal: PB/QSQJRN. Current Journal Receiver: PB/QSQJRN8836. Current Journal Sequence Number: 1. Previous Journal Sequence Number: 75.
This is likely due to Journal Sequence Number has been reset for the journal PB/QSQJRN.
Review this and postition the extract manually on the new journal receiver and start the extract.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document