Select From DB2 v10 on zOS Using DG4DRDA 11.2 Fails With ORA-28511
(Doc ID 1508982.1)
Last updated on FEBRUARY 04, 2019
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
A select using a join between an Oracle table and a table in DB2 v10 on IBM zOS gives the following error -
SQL> SELECT /*+ index(a,IDX$$_3D280001) */ '0' || substr(user_name,3,12) as
USER_NAME
from oracle.test_user a, db2.testdaily@test b
where substr(SSN,6,4) = '4366' AND DATE_OF_BIRTH ='04/04/1960' AND ZIP_CODE
= '10803'
AND substr(USER_NAME,0,4) = '9500' and substr(a.user_name,5,12) in
b.ACCOUNT_NUM;
AND substr(USER_NAME,0,4) = '9500' and substr(a.user_name,5,12) in
b.ACCOUNT_NUM
*
ERROR at line 4:
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testhost)(PORT=1528))(CONNEC
T_
DATA=(SID=dg4db2)))
ORA-28509: unable to establish a connection to non-Oracle system
ORA-02063: preceding line from TEST
Process ID: 1215
Session ID: 7 Serial number: 44051
USER_NAME
from oracle.test_user a, db2.testdaily@test b
where substr(SSN,6,4) = '4366' AND DATE_OF_BIRTH ='04/04/1960' AND ZIP_CODE
= '10803'
AND substr(USER_NAME,0,4) = '9500' and substr(a.user_name,5,12) in
b.ACCOUNT_NUM;
AND substr(USER_NAME,0,4) = '9500' and substr(a.user_name,5,12) in
b.ACCOUNT_NUM
*
ERROR at line 4:
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testhost)(PORT=1528))(CONNEC
T_
DATA=(SID=dg4db2)))
ORA-28509: unable to establish a connection to non-Oracle system
ORA-02063: preceding line from TEST
Process ID: 1215
Session ID: 7 Serial number: 44051
A gateway debug trace shows the SQL passed by the gateway is -
I[ 0] StatementHandle :h01004d4e30
I[ 1] StatementText :(0100403cd8) <len 67>
00: 53454C45 43542022 4143434F 554E545F [SELECT "ACCOUNT_]
10: 4E554D22 2046524F 4D202244 48533031 [NUM" FROM "DB2]
20: 222E2253 41564544 41494C59 22205748 ["."TESTDAILY" WH]
30: 45524520 22414343 4F554E54 5F4E554D [ERE "ACCOUNT_NUM]
40: 223D3F ["=?]
I[ 1] StatementText :(0100403cd8) <len 67>
00: 53454C45 43542022 4143434F 554E545F [SELECT "ACCOUNT_]
10: 4E554D22 2046524F 4D202244 48533031 [NUM" FROM "DB2]
20: 222E2253 41564544 41494C59 22205748 ["."TESTDAILY" WH]
30: 45524520 22414343 4F554E54 5F4E554D [ERE "ACCOUNT_NUM]
40: 223D3F ["=?]
- that is with a bind variable for the ACCOUNT_NUM.
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 |