OGG 12.2 Z/OS DB2v11 DEFGEN FAILURE (Doc ID 2254635.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 to 12.2.0.1.0 [Release 12.2]
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

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