IBM Support

IT35021: High CPU and decreased performance with high concurrency of index creation (on TEMP TABLES)

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

  • Db2 by default uses the compression for indexes on
    created/declared temporary tables (CGTTs/DGTTs) and this
    behavior cannot be explicitly disabled, that is, there is no
    possibility to use "COMPRESS NO" keyword.
    Index compression feature availability is predicated on Db2
    license type, which is checked during index creation and
    requires a serialization via a latch (mutex).
    If indexes are created with a very high concurrency the
    performance of that operation can be affected and CPU usage on
    the system will increase. This typically happens with a
    scenarios involving indexes on declared/created temporary tables
    that have indexes defined.
    A backtrace of Db2 engine threads (EDUs) collected during the
    issue with a debugger/profiler or "db2pd -stack" will show a
    call stack with the following functions near the top:
    
    ossLockGetConflict
    NetlsRequestLicense
    LicGetAccessKey
    sqllcRequestAccess
    sqloSqlcRequestAccess
    sqloLicRequestAccess
    sqldIndexType
    sqldIndexCreate
    sqlrlRecreateSingleIndex
    sqlrlRecreateIndexObject
    sqlrlRecreateIndexes
    
    This APAR will address the behavior by reducing the frequency of
    license type checks.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade to 11.1.4.6 or higher                                *
    ****************************************************************
    

Problem conclusion

  • upgrade to 11.1.4.6 or higher
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT35021

  • 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-11-23

  • Closed date

    2021-03-12

  • Last modified date

    2021-03-12

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IT35082

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:
13 March 2021