Bug 22600060 - COBOL PGM ON Z/OS THROUGH ODP4DRDA GETS SQLCODE -30020 W/ DDM CODE POINT 124C (Doc ID 2119521.1)

Last updated on DECEMBER 21, 2016

Applies to:

Oracle Database Provider for DRDA - Version 12.1.0.2 and later
DB2 for z/OS - Version 8.1 and later
Linux x86-64

Symptoms

Unable to convert process to Oracle Database Provider for DRDA (ODP4DRDA)
due to DRDA protocol error or Data Stream Syntax Error
(sqlcode=-30020 with DDM code point 124C - SYNTAXRM), which occurred after it
fetched 100 rows;  
While running COBOL code on z/OS, with connection  from DB2 v11 on z/OS,  
through ODP4DRDA 12.1.0.2 on Linux x86-64 RHEL5 to Oracle Database 11.2.0.3
on Linux x86-64 RHEL5, the following DDM code points were found in ODP4DRDA
trace "pp_1052_drdaas.trc", which also shows we are building a non-supported Streaming Layer B reply object:
 

 

ComputeHdrSize: ++ hdr(8004,241B,(36646)) => 8F2A(36650) Stream/noEL
ComputeDSSSize: + hdr(xxxx,D003,0001) => 8F30(36656)
CMN:SendDSSChain DSS 0xf9829c8 is 36656 bytes
D003 0001 ; Object DSS, not chained, don't continue, different request
ll=8004 ; (Streaming/EL)
241B ; QRYDTA
Dumping 'QRYDTA' addr=0xf969e2a size=32757 bytes

 

ALERT: short receive, 0 bytes, wanted 2
ALERT "hdr < 2" for PID 1052: REPLYCP-1232, RAISECP-1232, CODE-0040, SVRCOD-0040
ALERT: short receive, 0 bytes, wanted 4
ALERT "hdr < 6" for PID 1052: REPLYCP-124C, RAISECP-114A, CODE-0001, SVRCOD-0008

 

Running COBOL code on z/OS receives DSNT408I (SQLCODE = -30020) with
connection through DB2 v11 on z/OS:

  

 

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