DB2 - Problem description
Problem IT32367 | Status: Closed |
SQL0302N - DB2CI CLOB/BLOB PROCESSING FOR COLUMNS GREATER 1 MB | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem 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 db2trace 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 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5m4fp0 or later * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 31.03.2020 30.06.2020 30.06.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |