IBM Support

IT19533: SIGNIFICANT INCREASE IN SHARED APPLICATION HEAP AFTER UPGRADE TO10.5 FOR QUERIES REFERENCING RANGE PARTITIONED TABLES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In DB2 10.5 release number of object metrics available for
    monitoring was extended, which results in slightly higher
    dynamic section size for compiled SQLs. Difference is
    insignificant unless given query references table containing
    very high number of tables or, more likely, tables containing
    multiple partitions (>1000) because the metrics are maintained
    for each object separately. This increase will be exposed even
    more significantly in environments with high paralelism level
    (INTRA_PARALLEL=YES). Allocations will be shown in:
    $ db2pd -db <db_name> -memblocks appl top  20
    output with "File" ID 1127556507, e.g:
    PoolID  PoolName  TotalSize(Bytes)   %Bytes TotalCount . LOC
    File
    20      appshrh   8068968184         50.16  4803       . 1592
    1127556507
    20      appshrh   6946287888         43.18  4260       . 1729
    1127556507
    20      appshrh   379804896          2.36   6489       . 1515
    1127556507
    20      appshrh   136376208          0.85   8874       . 5146
    1095929873
    20      appshrh   16798208           0.10   3052       . 739
    1234005865
    
    This APAR will address this behavior and reduce memory footprint
    for such SQLs.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher               *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 11.1 Mod 2 Fix Pack 2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT19533

  • 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

    2017-03-03

  • Closed date

    2017-06-23

  • Last modified date

    2017-06-23

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

    IT14154

  • 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

[{"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","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 June 2020