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 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 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
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
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
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
| Symptoms |
| Cause |
| Solution |
| References |