IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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