My Oracle Support Banner

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 to [Release 11.2]
Information in this document applies to any platform.


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
 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
AND substr(USER_NAME,0,4) = '9500' and substr(a.user_name,5,12) in
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
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                               ["=?]


- that is with a bind variable for the ACCOUNT_NUM.




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.