Get SQLCODE -805 Looking for package named QSQCLIPx when connecting from DB2 on AS400 through DP4DRDA

(Doc ID 2179330.1)

Last updated on OCTOBER 02, 2017

Applies to:

Oracle Database Provider for DRDA - Version 12.1.0.2 and later
Linux x86-64
IBM i on POWER Systems

Symptoms

User session gets -901 SQLCODE on AS400 when selecting from only one table and setup is working fine when selecting data from other tables;

The DP4DRDA trace shows SQLCODE -805 occurred Looking for package OMSD QSQL400.QSQCLIPN [D8E2D8C3D3C94040]

Connection is from DB2 on AS400 v7.2 (iSeries), through "Oracle Database Provider for DRDA" (DP4DRDA) 12.1.0.2 running on Linux x86-64,
to Oracle 12.1.0.2 Database on Linux x86-64;

 


Trace file /u01/app/oracle/diag/dps/drdaas/drdaproc/trace/pp_5863_drdaas.trc
Entering dpstsich, CH= 0xfa1048 at 2016-08-16 10:13:57.888649000
Init Task #1
Exiting dpstsich, RC= 0 at 2016-08-16 10:13:57.888875000
Entering dpstssal, TX= 0xfa1048 at 2016-08-16 10:13:57.888891000
MyMemoryFree(0x104e2c0)
MyMemoryAlloc(8008) => 0x1051250
Entering PpInitializeSession at 2016-08-16 10:13:57.888931000
Initializing drdactx 0x10512c8 heap 0x1050f08
MyMemoryAlloc(4280) => 0x104e2c0
Exiting PpInitializeSession, rc= 0 at 2016-08-16 10:13:57.888991000
Session 0x1050f90
Exiting dpstssal, RC= 0 at 2016-08-16 10:13:57.889013000
MyMemoryAlloc(4240) => 0x1055ac0
Entering dpstscal, TX= 0xfa1048 at 2016-08-16 10:13:57.889034000
Entering dpsiocc, TX= 0xfa1048 at 2016-08-16 10:13:57.889048000
MyMemoryAlloc(4280) => 0x1056b60
MyMemoryAlloc(4280) => 0x1057c20
MyMemoryAlloc(4280) => 0x1058ce0
Connection 0x1056850
Exiting dpsiocc, RC= 0 at 2016-08-16 10:13:57.889089000
Exiting dpstscal, RC= 0 at 2016-08-16 10:13:57.889102000
Calling nsinherit, 0x10566f0
Calling nsaccept, 0x10566f0
MyMemoryAlloc(4240) => 0x1061b70
Start drdaas

===

dpsadpecPackageExistsCT: Looking for package OMSD QSQL400.QSQCLIPN [D8E2D8C3D3C94040]
MyMemoryAlloc(4200) => 0x11201c0
MyMemoryAlloc(4240) => 0x1121230
1.0: OCIStmtPrepare2(@0x1120b38,0x526e80,82,L=1) -> RC=0
2.0: OCIBindByName(h0x1120b38,'doexist_rc',0x7fff06df8b50,4,3) -> RC=0
2.0: OCIBindByName(h0x1120b38,'collid',0x111c770,7,1) -> RC=0
2.0: OCIBindByName(h0x1120b38,'pkgid',0x111c740,8,1) -> RC=0
2.0: OCIBindByName(h0x1120b38,'cnstkn',0x111c818,8,23) -> RC=0
3.0: OCIStmtExecute(h0x1120b38) -> RC=0
4.0: OCIStmtRelease(h0x1120b38) -> RC=0
Bind doexist_rc(1) to -20983
Bind collid(2) to QSQL400
Bind pkgid(3) to QSQCLIPN
Bind cnstkn(4) to D8E2D8C3D3C94040
Exiting dpsadpecPackageExistsCT, rc= 0 at 2016-08-16 10:13:57.982020000
dpsadpecPackageExistsCT: rc=0, exists_rc=-20983
At send_sqlcode_805
Entering SQLCASet, SQLCA= 0x107d2d8 at 2016-08-16 10:13:57.982099000
SQLCA item 228
Entering SQLCASet, SQLCA= 0x107d2d8 at 2016-08-16 10:13:57.982131000
SQLCA item 104
Exiting SQLCASet, RC= 0 at 2016-08-16 10:13:57.982166000
sqlerrmsg: OMSD.QSQL400.QSQCLIPN.D8E2D8C3D3C94040
SQLCA item 610
sqldctok: OMSD.QSQL400.QSQCLIPN.D8E2D8C3D3C94040
Exiting SQLCASet, RC= 0 at 2016-08-16 10:13:57.982293000
Calling dpsadass_SQLCASet...
Entering SQLCASet, SQLCA= 0x107d2d8 at 2016-08-16 10:13:57.982339000
SQLCA item 101
SQLCASet: sqlcode=-805

===

Entering dpsaaptwep_PpTaskWorkEntryPoint at 2016-08-16 10:25:44.639664000
CMN:RecvDSSChain DSS 0x11180e0
ALERT: short receive, 0 bytes, wanted 2
ALERT "hdr < 2" for PID 5863: REPLYCP-1232, RAISECP-1232, CODE-0040, SVRCOD-0040
ALERT: short receive, 0 bytes, wanted 4
ALERT "hdr < 6" for PID 5863: REPLYCP-124C, RAISECP-114A, CODE-0001, SVRCOD-0008

 

 

 

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