My Oracle Support Banner

GoldenGate For DB2 Extract Abends With Db2ReadLog Error (Doc ID 1609907.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle GoldenGate - Version 11.2.1.0.14 and later
Information in this document applies to any platform.
DB2 database allowed to write a single log record longer than the output buffer provided to api function. And DB2 9.7 with fixpack 9 has a parameter to increase this size of the buffer, but GoldenGate extract failed to capture this larger buffer record. To solve it, use larger bufsize of OGG parameter also can solve the issue.

You can get ogg extract abend error when read this kind of larger over buffered record:
2013-12-09 15:22:26 ERROR OGG-00816 Oracle GoldenGate Capture for DB2, eregrfo.prm: db2ReadLog error [SC=-2650:SQL2650N An invalid parameter "poLogBuffer" was passed to the "db2ReadLog" read log API. Reason Code = "8"] [The buffer is not of sufficient size to store a log record].

to solve this issue, add larger buffer size with following parameter in extract parameter file.

TRANLOGTOPIONS BUFSIZE

Symptoms

 

You can get ogg extract abend error when read this kind of larger over buffered record:
2013-12-09 15:22:26 ERROR OGG-00816 Oracle GoldenGate Capture for DB2, <capture_name>.prm: db2ReadLog error [SC=-2650:SQL2650N An invalid parameter "poLogBuffer" was passed to the "db2ReadLog" read log API. Reason Code = "8"] [The buffer is not of sufficient size to store a log record].

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.