OGG Extract - z/OS DB2 abends ODBC Error: SQLCODE -805 (Doc ID 1419328.1)

Last updated on JANUARY 18, 2017

Applies to:

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

Symptoms

Extract abends with :
012-02-17 11:45:03 ERROR OGG-01400 Database operation failed: Couldn't connect to ADG0. ODBC error: SQLCODE -805. ODBC error detail is not available - please check that the ODBC configuration is complete, including the DB2 BIND for ODBC plans & packages.
{DB2 FOR OS/390}{ODBC DRIVER} DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME ADG0..DSNCLIC1.18D2EEFA10131BA4 NOT FOUND IN PLAN DSNACLI. REASON 03

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