Fixes are available
APAR status
Closed as program error.
Error description
On column-organized table, this occurs in an edge case during updates and inserts where page compression was not re-evaluated correctly, leading to some inconsistencies between the page state and page dictionary. The following similar message logged in db2diag.log can be found during the reproduction. 2020-02-20-22.18.03.775259+540 I727550E4019 LEVEL: Error PID : 120164 TID : 140378183296768 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : DBNAME APPHDL : 0-1276 APPID: *LOCAL.db2inst1.200220132853 UOWID : 2 ACTID: 1 AUTHID : DB2INST1 HOSTNAME: hostname EDUID : 267 EDUNAME: db2agent (DBNAME) 0 FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:2630 DATA #1 : String, 347 bytes AssertionFailedException: An assertion 'targetColSpec.getWidthInBits() < sourceColSpec.getWidthInBits()' failed. Additional info: page dictionary does not reduce column width: target col width = 15 source col width = 15 target col index = 29 source col index = 29 col[index = 29 name = COLUMNNAME type = T1(192,1208)] Thrown at TableWriter.cpp : 2630 DATA #2 : Function name in Library, 161 bytes void ibm_cde::data::TableWriter::rewriteRegion(ibm_cde::data::ColumnG roup &, ibm_cde::data::RegionWriteState *, ibm_cde::data::RegionWriteState *, unsigned long) DATA #3 : File name, 15 bytes TableWriter.cpp CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00007FF93A779F69 _ZN7ibm_cde8services6Tracer9traceDataENS0_11ComponentIDENS0_16Co mmonTraceLevelENS1_10TraceEventEPKcmS6_PKvmRKSbIcSt11char_trait + 0x369 [1] 0x00007FF93A716392 _ZNK7ibm_cde8services13BaseException14traceExceptionENS0_11Compo nentIDEPKc + 0x322 [2] 0x00007FF93A70D009 _ZN7ibm_cde8services24AssertionFailedException17constructAndThro wENS0_11ComponentIDEPKcmS4_S4_RNS0_16CdeOStringStreamE + 0xF9 [3] 0x00007FF93AE71276 /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x2B9F276 [4] 0x00007FF93B025787 _ZN7ibm_cde4data21ColumnGroupWriteState23copyAndCompressPageData EPKNS0_4PageERKNS_8services12VectorOfPtrsINS0_16RegionWriteStat + 0xA87 [5] 0x00007FF93B023A55 _ZN7ibm_cde4data21ColumnGroupWriteState31compressAndRewritePageF orInsertEv + 0x815 [6] 0x00007FF93AE5B33C _ZN7ibm_cde4data11TableWriter32insertTupleToColumnGroupBufferedE RKSt6vectorIPKNS_5types10ValUncodedENS_8services9AllocatorIS6_E + 0x37C [7] 0x00007FF93AE7C7A0 _ZN7ibm_cde4data11TableWriter20insertTuplesBufferedERKNS0_16Tabl eTupleSourceEPNS0_17TableIndexUpdaterERNS_5types10SQLWarningE + 0x450 [8] 0x00007FF93AF45A4B _ZN7ibm_cde4data13TableAccessor17insertRowInternalERKNS0_18Uncod edInsertTupleERNS0_17TableIndexUpdaterEbPKmmRNS_5types10SQLWarn + 0xEB [9] 0x00007FF93AF471BC _ZN7ibm_cde4data13TableAccessor9insertRowERKSt6vectorINS_5types8 DataTypeENS_8services9AllocatorIS4_EEERKS2_IPKNS3_10ValUncodedE + 0x88C [10] 0x00007FF93C889D81 _ZN25cdeTableAccessorInterface19decomposedUpdateRowEmmPK18sqlriC deColumnListS2_P26cdeDirectInsertTupleHandlelP10SQLI_IXPCR + 0xA31 [11] 0x00007FF93C888AE6 _ZN12cdeInterface13performUpdateEmmPK18sqlriCdeColumnListS2_P26c deDirectInsertTupleHandlelP10SQLI_IXPCR + 0x336 [12] 0x00007FF940325105 _Z18sqlriCdeFastUpdateP8sqlrr_cb + 0x245 [13] 0x00007FF9403B79BD _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x4BD [14] 0x00007FF93FDCB0A0 _Z23sqlrr_execute_immediateP8sqlrr_cbi + 0x590 [15] 0x00007FF93FDAC501 _Z14sqlrr_execimmdP14db2UCinterfaceP16db2UCprepareInfo + 0x841 [16] 0x00007FF93DF12FEF _Z19sqljs_ddm_excsqlimmP14db2UCinterfaceP13sqljDDMObject + 0x3EF [17] 0x00007FF93DEDA9EB _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U Cinterface + 0x11B [18] 0x00007FF93DEDBA9E _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x54E [19] 0x00007FF93DECE97D /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x5BFC97D [20] 0x00007FF93DED4F63 /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x5C02F63 [21] 0x00007FF93DED5C1F _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x11F [22] 0x00007FF93D8FF543 _ZN8sqeAgent6RunEDUEv + 0xDE3 [23] 0x00007FF94121EF5E _ZN9sqzEDUObj9EDUDriverEv + 0x1BE [24] 0x00007FF93F74530A sqloEDUEntry + 0x57A [25] 0x00007FF9472D9E25 /lib64/libpthread.so.0 + 0x7E25 [26] 0x00007FF936D8434D clone + 0x6D
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * column-organized table user * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 11.1 Modification 4 FixPack 6 or * * later * ****************************************************************
Problem conclusion
Fixed in DB2 Version 11.1 Modification 4 FixPack 6
Temporary fix
Comments
APAR Information
APAR number
IT32080
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-03-04
Closed date
2021-03-31
Last modified date
2021-03-31
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
RB10 PSN
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022