My Oracle Support Banner

OGG 12.2 Z/OS DB2v11 Extract fails with ERROR OGG-00551 ODBC error SQLSTATE S1001 native database error -99999 ERRLOC=8:1:2 (Doc ID 2254635.1)

Last updated on MAY 11, 2022

Applies to:

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

Symptoms

Using GG version 12.2.0.1.0 for DB2, running on Z/OS 1.10 platform, defgen fails with the following

2017-01-16 11:24:58 ERROR OGG-00551 Database operation failed: Fetching tables query. ODBC error: SQLSTATE S1001 native database error -99999. {DB2 FOR OS/390}{ODBC DRIVER} SQLSTATE=S1001 ERRLOC=8:1:2.

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.