IBM Support

PK98337: ABEND04E DSNGEPIS DSNSVBK OFFSET061A RC00E20003 DURING REPAIR DBD DIAGNOSE ON DATABASE WITH MANY TRIGGERS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DBM1 storage is not being freed when running REPAIR DBD DIAGNOSE
    nd the storage growth is connected to the number of triggers in
    the database. Abend04e in DSNGEPIS DSNSVBK OFFSET061A with
    RC000E20003.
    .
    2/ ABEND04E RC00E20004DSNXEAB DSNSVSVB 0446
    also possible with PHB at MAX size / 2G /
     ADMF AGL 64 XXXXXXXX     Var      2097064 K  20   0
    in storage above the bar
    DSNXOOP  +004F15 UK45067
    DSNXOAF  +000931 UK28994
    are major storage consumers
    DB2STGLK/K
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 users who use REPAIR DBD utility     *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E RC00E20003 DSNGEPIS.DSNSVBK    *
    *                      061A or ABND04E RC00E20004              *
    *                      DSNXEAB.DSNSVSVB 0446 may occur when    *
    *                      performing REPAIR DBD DIAGNOSE on       *
    *                      database with many triggers             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    ABEND04E RC00E20003 DSNGEPIS.DSNSVBK 061A or ABND04E RC00E20004
    DSNXEAB.DSNSVSVB 0446 may occur when performing REPAIR DBD
    DIAGNOSE on a database with many triggers.
    The ABEND is caused by a storage shortage during REPAIR DBD
    processing.
    When the REPAIR DBD utility is processing the triggers in the
    database, it is not properly freeing acquired storage.  When
    the number of triggers in the database is high, this causes
    DB2 to run out of storage when executing REPAIR DBD DIAGNOSE
    utility.
    

Problem conclusion

  • DB2 is modified to free storage properly when executing utility
    REPAIR DBD DIAGNOSE.
    Additional keywords: SQLSTORAGE SQLTRIGGER
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK98337

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-10-09

  • Closed date

    2009-11-23

  • Last modified date

    2011-02-15

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

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

    UK52223 UK52224

Modules/Macros

  • DSNXOOP
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R810 PSY UK52223

       UP09/12/10 P F912

  • R910 PSY UK52224

       UP09/12/10 P F912

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":"8.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":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
15 February 2011