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 03, 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

 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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.