OGG Extract V12.2 z/OS DB2 V11 Abended Due To Timestamp Format Error

(Doc ID 2152249.1)

Last updated on APRIL 18, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
IBM z/OS on System z

Symptoms

12.2.0.1.0 version, 2 - z/OS DB2 V11.1 Extract

When attempting to start the extract, extract abends with:

ERROR
-----------------------
ERROR OGG-00551 Database operation failed: Retrieving encoding information for <table name>  ODBC error: SQLSTATE 22007 native database error -180.

{DB2 FOR OS/390}{ODBC DRIVER}{DSN11010}


DSNT408I SQLCODE = -180, ERROR: THE DATE, TIME, OR TIMESTAMP VALUE <timestamp>  IS INVALID

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