OGG z/OS DB2 Extract Abends : ERROR OGG-00551 Database operation failed: Couldn't connect ..... ODBC error: SQLSTATE 08001 native database error -3008 (Doc ID 1488092.1)

Last updated on JANUARY 18, 2017

Applies to:

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

Symptoms

Extract abends:

Source Context :
  SourceModule : [ggdb.odbc.dbx]
  SourceID : [./../gglib/ggdbodbc/dbxodbc.c]
  SourceFunction : [gl_check_odbc_err(SQLHENV, SQLHDBC, SQLHSTMT, short, short, char *, SQLRETURN, const char *, ...)]
  SourceLine : [1396]

2012-08-31 08:32:30 ERROR OGG-00551 Database operation failed: Couldn't connect to db2ds4a. ODBC error: SQLSTATE 08001 native database error -30081. {DB2 FOR OS/390}{ODBC DRIVER}
 DSNT408I SQLCODE = -30081, ERROR: COMMUNICATIONS ERROR DETECTED. API=,
  LOCATION=, FUNCTION=
  ERROR CODES=
 DSNT418I SQLSTATE = 08001 SQLSTATE RETURN CODE
 DSNT415I SQLERRP = DSNLIENO SQL PROCEDURE DETECTING ERROR
 DSNT416I SQLERRD = 9 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
 DSNT416I SQLERRD = X'00000009' X'00000000' X'00000000' X'FFFFFFFF'
  X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
  ERRLOC=1:13:1.

2012-08-31 08:32:30 ERROR OGG-01668 PROCESS ABENDING.

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