ORA-28500 Using DG4DRDA 11.2 Against DB2 zOS v10 Running in v8 Compatibility Mode (Doc ID 1514479.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database Gateway for DRDA - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Using Database Gateway for DRDA (DG4DRDA) 11.2.0.3 on AIX to select from DB2 v10 in v8 compatibility mode on zOS gives the following error -

SQL> select count(*) from T1.ICMDB@DG4DRDA.WORLD;
select count(*) from T1.ICMDB@DG4DRDA.WORLD
                          *
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from DG4DRDA.WORLD

 

A DG4DRDA 255 level trace ends at the following point -

hgotcis, line 452: calling SQLStatistics got sqlstate
ENTER SQLFreeStmt [2 args]
I[ 0]           StatementHandle :h0110789890
I[ 1]                    Option :          2 <SQL_UNBIND>
----> RC=0 <SQL_SUCCESS> (TRC=0)
EXIT  SQLFreeStmt [2 args]
I[ 0]           StatementHandle :h0110789890
I[ 1]                    Option :          2 <SQL_UNBIND>
Exiting hgotcis, rc=28500 at 2012/12/19-10:11:04 with error ptr FILE:hgotcis.c LINE:452 ID:SQLStatistics
hostmstr:     499800: HOA After hoxtcis
hostmstr:     499800: RPC After Get Statistics

 

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