IBM Support

PI15854: DB2 STORAGE MANAGEMENT ENHANCEMENT FOR RUNTIME UPROC

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Qrep users may notice excessive storage use of below the bar
    storage. Blocks are with eyecatcher "UZB" and the allocator is
    DSNIZREP (UK60956 offset x'2BA').
    
    AI has been added to UI19147 (2014/08/01):
    This PTF additionally fixes problem with serialisation
    between CREATE  / ALTER index and other concurrent DML
    operations, which may lead to data inconsistency between data
    and index.
    For example for UPDATE operations may not see a new key column
    being added into the existing index and miss the key inserts.
    DB2INCORR/K DATALOSS
    

Local fix

  • decrease MAXKEEPD or reduce number of Qrep agents
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: DB2 10 for z/OS users run UPDATE statements  *
    ****************************************************************
    * PROBLEM DESCRIPTION: DB2 run into a storage shortage issue   *
    *                      when multiple UPDATE statements are     *
    *                      executed concurretly under dynamic      *
    *                      cache environment.                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Under dynamic cache environment, after UPDATE statements are
    run, DB2 may not free its associated UPROC storage due to
    performance reason.  The storage for UPROCs may therefore be
    accumulated and cause a storage shortage in DB2.
    

Problem conclusion

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

  • DB2 code is modified to provide a relief of storage leak due to
    the accumulated UPROCs.  DB2 will use a UPROC built at dynamic
    cache prepare time and avoid to create another UPROC at runtime.
    DB2 will invalidate dynamic cache packages and quiesce the use
    count at CREATE and ALTER INDEX time to ensure the UPROC's
    consistent state.  The logic change may cause potential SQLCODE
    -904 for CREATE and ALTER INDEX.
    ž**** PE15/02/18 PTF IN ERROR. SEE APAR PI32317  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PI15854

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-04-11

  • Closed date

    2014-06-25

  • Last modified date

    2015-02-18

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

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

    UI19147

Modules/Macros

  • DSNILREP DSNXICIX DSNXICX2 DSNXODML
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI19147

       UP14/07/11 P F407

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
18 February 2015