IBM Support

IT24078: DB2 MAY HIT SUSTAINABLE TRAP IN SQLNO_CREATE_TEMPORAL_KEYS PROCESSING

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Problem happens in function that analyzes a temporal table
    access. The problem can be hit if the query contains AS OF
    predicates and there are more than 1 BTWO (Business time without
    overlap) indexes on the table. Even if these conditions are
    satisfied, it isn't guaranteed a user will hit the issue.
    
    The trap is sustainable, and top of the FODC stack is following:
    
    sqlno_exists_in_setP__FP13sqlno_globalsP9sqlno_sdbi9sqlno_set +
    0xF8
    sqlno_create_temporal_keys__FP13sqlno_globalsP9sqlno_qtbP11sqlno
    _tableP21sqlno_plan_properties13SQLNN_BOOLEANP16sqlno_listheader
    T4bPP16sqlno_listheader + 0x1064
    sqlno_key_build_prop__FP13sqlno_globalsP11sqlno_tableP21sqlno_pl
    an_properties + 0xCF8
    sqlno_prop_table_init__FP13sqlno_globalsP21sqlno_plan_properties
    P17sqlno_access_path9sqlno_setP10sqlno_partT4P18sqlno_join_conte
    xtP13SQLNN_BOOLEANb + 0x1C80
    sqlno_prop_iscan__FP13sqlno_globalsP13sqlno_contextP21sqlno_plan
    _propertiesP19sqlno_plan_function + 0x348
    ISCAN__FP13sqlno_globalsP13sqlno_contextP17sqlno_access_pathP16s
    qlno_dpart_elim9sqlno_setT5P16sqlno_ixkeycondsT7T5P20sqlno_qun2p
    lan_array13SQLNN_BOOLEANT5fPP19sqlno_plan_operatorUsT11_P10sqlno
    _partN211_b + 0x464
    ...
    

Local fix

  • NA
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT24078

  • 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

    2018-02-15

  • Closed date

    2018-11-27

  • Last modified date

    2018-11-27

  • 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":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
27 November 2018