My Oracle Support Banner

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

Last updated on MAY 11, 2022

Applies to:

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


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

SQL> select count(*) from OWNER.TABLE@DG4DRDA.WORLD;
select count(*) from OWNER.TABLE@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



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.