DB2 - Problem description
Problem IT36924 | Status: Closed |
IN A RARE SCENARIO THE ERROR COULD BE LOST AND INSTEAD EITHER NULL OR SQL0901N returned | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
IN A RARE THE ERROR COULD BE LOST AND INSTEAD EITHER NULL OR SQL0901N returned. IF AN OPERATION ON A VARIABLE-LENGTH COLUMN IN COLUMNAR ORGANIZED PROCESSING, THE ERROR COULD BE LOST AND INSTEAD EITHER NULL OR SQL0901N RETURNED. COLUMN MUST BE PROCESSED AS COLUMNAR ORGANIZED - TABLE MUST BE CREATED WITH "ORGANIZED BY COLUMN" COLUMN MUST BE VARIABLE LENGTH. example of SQL0901N: MESSAGE : SQL0901N The SQL statement or command failed because of a database system error. (Reason "".) DATA #1 : '!(column.colZValue->ind & ((SQLZVALUE_IND_T)0x0002))' failed. Info: writing null to non-null col 31 CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00007F36DCAB6E5D pdLogPrintf + 0x8D [1] 0x00007F36DD55BC1D _ZN7ibm_cde8services24AssertionFailedException4doneEv + 0x78D [2] 0x00007F36DD55F159 _ZN7ibm_cde8services24AssertionFailedException17constructAndThro wENS0_11ComponentIDEPKcmS4_S4_RNS0_16CdeOStringStreamE + 0x149 [3] 0x00007F36E02F1D5D _ZN12cdeInterface5fetchEP8sqlrr_cbR17cdeIteratorHandleP18sqlriCd eColumnList + 0x5ED [4] 0x00007F36E506DA70 _Z13sqlriCdeQueryP8sqlrr_cb + 0x2E0 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Columnar variable length data * **************************************************************** * PROBLEM DESCRIPTION: * * Upgrade to 11.5.6 or later * **************************************************************** * RECOMMENDATION: * * See Error Description, please, install the fix. * **************************************************************** | |
Local Fix: | |
N/A | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Columnar variable length data * **************************************************************** * PROBLEM DESCRIPTION: * * Upgrade to 11.5.6 or later * **************************************************************** * RECOMMENDATION: * * See Error Description, please, install the fix. * **************************************************************** | |
Comment | |
Upgrade to 11.5.6 or later | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.05.2021 21.06.2021 23.06.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |