Select From DB2 v10 on zOS Using DG4DRDA 11.2 Fails With ORA-28511 (Doc ID 1508982.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

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

 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.

 

 

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