DBLOGIN To z/OS DB2 Database Failed with Error Message:Database operation failed: SQLAllocConnect 0

(Doc ID 1458636.1)

Last updated on JANUARY 18, 2017

Applies to:

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

Symptoms

GGSCI> DBLOGIN SOURCEDB {data source}, USERID {database userid}, PASSWORD {database password}

When logging into the database through GGSCI we receive the following errors:

2012-04-24 15:05:49 WARNING OGG-00552 Database operation failed: Couldn't connect to IBCDBT1 for catalog queries. ODBC error: SQLS
TATE 08001 native database error -99999. {DB2 FOR OS/390}{ODBC DRIVER} SQLSTATE=08001 ERRLOC=2:23:3.
ERROR: Failed to open data source IBCDBT1 for user proddb.

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