OGG z/OS Extract abend: "ERROR OGG-00551 Database Operation Failed: Listing Table" (Doc ID 2085348.1)

Last updated on JANUARY 09, 2017

Applies to:

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

Symptoms

z/OS DB2 Extract:

Oracle GoldenGate Capture for DB2
Version 11.2.1.0.29 20493405 OGGCORE_11.2.1.0.0OGGBP_PLATFORMS_150302.0345
z/OS 1.08, UDB91 on Mar 3 2015 10:58:22

Database Version:
DSN10015
Version 10.01.0005
ODBC Version 03.01.0000

Driver Information: DSNAOCLI Version 10.01.0000 ODBC Version 03.00
Database Language and Character Set:
ASCII: SCCSID = 850, MCCSID = 65534, DCCSID = 65534
EBCDIC: SCCSID = 284, MCCSID = 65534, DCCSID = 65534

which fails with error during startup:

Source Context :
  SourceModule : Ýggdb.odbc.util~
  SourceID : Ý./../gglib/ggdbodbc/odbcutil.c~
  SourceFunction : ÝODBCUTIL_check_err(RETCODE, SQLHENV, SQLHDBC, SQLHSTMT, short, const char *, ...)~
  SourceLine : Ý1724~

2015-11-30 12:02:43 ERROR OGG-00551 Database operation failed: Listing tables. ODBC error: SQLSTATE 00000 native database error 0. ODBC return code: -1. No additional information available.

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