Ogg Db2 Extract Fails With Error Ogg-00816 Db2readlog Error [Sc=-2650:Sql2650n An Invalid Parameter "Pistartlsn" Was Passed To The "Db2readlog" Read Log Api. Reason Code = "4" When Altered With Begin Now (Doc ID 1970383.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.38 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.1.0.38 version, 2 - Non Oracle DB backend

Extract was altered with begin now and on restart it looks for old log file and throws following error

ERROR
-----------------------
 ERROR OGG-00816 db2ReadLog error [SC=-2650:SQL2650N An invalid parameter "piStartLSN" was passed to the "db2ReadLog" read log API. Reason Code = "4"] [The starting log sequence number does not represent the start of an actual log record].

Changes

 Extract is altered with EOF or Begin now Or Begin timestamp

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