DB2DB2:EXTRACT ABEND DUE TO OGG-00817 DB2READLOG ERROR with DB2 10.5 (Doc ID 2258990.1)

Last updated on JULY 28, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 to 12.2.0.1.0 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

The gg user this db2 database is generationg large number of files in the db2dump location (/db2/fcc/home/sqllib/db2dump)
for example
2017-04-18-04.02.53.785784-300 I16697261A738 LEVEL: Info
PID : 7667754 TID : 47657 PROC : db2sysc 0
INSTANCE: fcc NODE : 000 DB : MMDB
APPHDL : 0-19915 APPID: *LOCAL.f8db2q3.170323152033
AUTHID : GGADMIN HOSTNAME: fcc.xyz.com
EDUID : 47657 EDUNAME: db2agent (MMDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpFlightRecorder::dumpEventRecorders, probe:1000
DATA #1 :
Dumped SQP flight recorder information to file "/db2/fcc/home/sqllib/db2dump/MMDB.20170418040253.000.SQLP.SHREDDER_MASTER.events.bin".
If IBM service is contacted to help resolve a recovery problem, this file may be requested.

2017-04-18-04.02.53.791896-300 I16698000A738 LEVEL: Info
PID : 7667754 TID : 47657 PROC : db2sysc 0
INSTANCE: fcc NODE : 000 DB : MMDB
APPHDL : 0-19915 APPID: *LOCAL.fcc.170323152033
AUTHID : GGADMIN HOSTNAME: fcc.xyz.com
EDUID : 47657 EDUNAME: db2agent (MMDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpFlightRecorder::dumpEventRecorders, probe:1000
DATA #1 :
Dumped SQP flight recorder information to file "/db2/fcc/home/sqllib/db2dump/MMDB.20170418040253.000.SQLP.SHREDDER_WORKER.events.bin".
If IBM service is contacted to help resolve a recovery problem, this file may be requested.

IBM PMR 52408,L6Q,000
IBM PMR 69810 011 724

Cause

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