APAR status
Closed as program error.
Error description
When using OCI functions OCILobGetLength and OCILobRead to read data from Db2 database, only LOB objects which are less or equal to 1 MByte are processed. If the objects are larger, it returns error: SQL0302N The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use. SQLSTATE=22001 A Db2 trace is showing this flow: 11584 4.524717000 sqloEDUEntry entry 11740 4.524968000 | sqzEDUObj::EDUDriver entry [eduid 347 eduname db2agent] 11864 4.525084000 | | sqeAgent::RunEDU entry [eduid 347 eduname db2agent] 11942 4.525278000 | | | sqljsDrdaAsDriver entry [eduid 347 eduname db2agent] 11943 4.525285000 | | | | sqljsDrdaAsInnerDriver entry [eduid 347 eduname db2agent] 12128 4.525440000 | | | | | sqljsDriveRequests entry [eduid 347 eduname db2agent] 12129 4.525442000 | | | | | | sqljsSqlam entry [eduid 347 eduname db2agent] 42577 4.817578000 | | | | | | | sqljsParse entry [eduid 347 eduname db2agent] 56002 4.821561000 | | | | | | | | sqljsParseRdbAccessed entry [eduid 347 eduname db2agent] 56003 4.821562000 | | | | | | | | | sqljs_ddm_opnqry entry [eduid 347 eduname db2agent] 56076 4.821590000 | | | | | | | | | | sqlrr_open entry [eduid 347 eduname db2agent] 56102 4.821604000 | | | | | | | | | | | sqlrr_process_open_request entry [eduid 347 eduname db2agent] 56127 4.821620000 | | | | | | | | | | | | sqlriSectInvoke entry [eduid 347 eduname db2agent] 56128 4.821621000 | | | | | | | | | | | | | sqlribni entry [eduid 347 eduname db2agent] 56129 4.821632000 | | | | | | | | | | | | | | sqlribniCbDrda entry [eduid 347 eduname db2agent] 56130 4.821633000 | | | | | | | | | | | | | | | sqlriBindinSwitch entry [eduid 347 eduname db2agent] 56131 4.821638000 | | | | | | | | | | | | | | | | sqlriBindinLocator entry [eduid 347 eduname db2agent] 56137 4.821643000 | | | | | | | | | | | | | | | | | sqlzeMapZrc entry [eduid 347 eduname db2agent] ... 56151 4.821659000 | | | | | | | | | | | | | | | | | sqlzeMapZrc errtrans [probe 40] [ ZRC = 0x80160056 = -2146041770 = SQLRXTRN --> SQL0302 ] 56152 4.821659000 | | | | | | | | | | | | | | | | | sqlzeMapZrc error [probe 50] [ ZRC = 0x80160056 = -2146041770 = SQLRXTRN] 56153 4.821659000 | | | | | | | | | | | | | | | | | sqlzeMapZrc exit
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 Version 11.1 Mod 4 FixPack 6. * ****************************************************************
Problem conclusion
First fixed in Db2 Version 11.1 Mod4 FixPack 6.
Temporary fix
Comments
APAR Information
APAR number
IT32404
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-04-02
Closed date
2021-03-16
Last modified date
2021-03-16
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]
Document Information
Modified date:
18 March 2021