OGG Replicat Abends On LOB Data. OGG Error: OGG-01028: Unexpected LOB Record Or Record Fragment In … (Trail File)
SYMPTOMS:
2018-10-06 18:13:43 ERROR OGG-02188 Unexpected LOB record or record fragment in /trail/DL000000016, rba 1,750.
CAUSE:
replicat altered to start on trail where the first record is a LOB and not the base record INSERT/UPDATE/DELETE
SOLUTION:
1. Use logdump to locate the base record in the trail previous to one replicat is processing. This will display the RBA number of the last base record in trail
rectype 03 – Delete
rectype 05 – Insert
rectype 15 – Update (FieldComp)
rectype 73 – Primary Key Update (GGSPKUpdate)
logdump> open <trail file>
logdump> ghdr on
logdump> pos eof
logdump> pos reverse
logdump> filter exclude rectype 116
logdump>n
2. Alter replicat to position to start on the base record
ggsci> alter <replicat>, extseqno ### ,extrba <RBA of record from above output>