Bug 22600060 - COBOL PGM ON Z/OS THROUGH ODP4DRDA GETS SQLCODE -30020 W/ DDM CODE POINT 124C
(Doc ID 2119521.1)
Last updated on AUGUST 31, 2023
Applies to:
Oracle Database Provider for DRDA - Version 12.1.0.2 and laterDB2 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
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 |