IBM Support

IT36924: IN A RARE SCENARIO THE ERROR COULD BE LOST AND INSTEAD EITHER NULL OR SQL0901N returned

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

  • 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 : <preformatted>
     '!(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
    

Local fix

  • N/A
    

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

Problem conclusion

  • Upgrade to 11.5.6 or later
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT36924

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-05-17

  • Closed date

    2021-06-21

  • Last modified date

    2021-06-23

  • 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":"BU029","label":"Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5"}]

Document Information

Modified date:
24 June 2021