DB2DB2:EXTRACT ABEND DUE TO OGG-00817 DB2READLOG ERROR with DB2 10.5
(Doc ID 2258990.1)
Last updated on MAY 11, 2022
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.
<Company Name> PMR 52408,L6Q,000
<Company Name> PMR 69810 011 724
Cause
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
Symptoms |
Cause |
Solution |
References |