IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
01 April 2021