OGG z/OS DB2 Extract WARNING OGG-00552 Database operation failed: Retrieving Application Encoding Scheme (Doc ID 1488113.1)

Last updated on JANUARY 18, 2017

Applies to:

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

Symptoms

OGG V11.2.1.0.1 z/OS DB2 running against DB2 8.x database

 Extract displays warning message:

2012-08-30 11:10:42 WARNING OGG-00552 Database operation failed: Retrieving Application Encoding Scheme. ODBC error: SQLSTATE 42815 native database error -171.
{DB2 FOR OS/390}{ODBC DRIVER}{DSN08015}
DSNT408I SQLCODE = -171, ERROR: THE DATA TYPE, LENGTH, OR VALUE OF ARGUMENT 1 OF GETVARIABLE IS INVALID
DSNT418I SQLSTATE = 42815 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXOBFA SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 715 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'000002CB' X'00000000' X'00000000' X'FFFFFFFF'
  X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
 ERRLOC=1:13:2.

2012-08-30 11:10:42 WARNING OGG-03026 Unexpected return code -1 received while attempting to retrieve the APPLICATION ENCODING SCHEME.

2012-08-30 11:10:42 INFO OGG-03037 Session character set identified as IBM037.

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