IT32080: SQL0901N ERROR WITH AN ASSERTION 'TARGETCOLSPEC.GETWIDTHINBITS()< SOURCECOLSPEC.GETWIDTHINBITS()' FAILED IN DB2DIAG.LOG

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 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