IBM Support

PH14392: DSNT500I RC00C90089 EDM DBD SPACE FULL

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Many messages about DBD space full with rc00c90089 type602 :
    DSNT500I  -DSN  DSNGEDLC RESOURCE UNAVAILABLE
                             REASON 00C90089
                             TYPE 00000602
                             NAME EDM DBD SPACE
    This apar is retrofit to v11 for PI98892.
    DBDPOOL full condition may occur on structure owner DB2 member
    due to DBD pages incorrectly not being marked stealable.
    During Group Buffer Pool check point process,  the Db2 internal
    cast out task can miss a de-reference call to the DBD
    it just referenced.  This missed de-reference call makes those
    DBD pages non-stealable.
    The number of stealable paged QISEDLRU decreases, in the end
    results in DBD POOL FULL condition DSNT500I REASON CODE
    RC00C90089 and RESOURCE TYPE 00000602.
    

Local fix

  • Increase EDM DBD CACHE dynamically.
    EDM DBD CACHE field , EDMDBDC subsystem parameter.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Db2 11 for z/OS users.                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: Database descriptor (DBD) POOL full     *
    *                      condition may occur due to database     *
    *                      descriptor(DBD) pages incorrectly       *
    *                      not being marked stealable.             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    During Group Buffer Pool check point process,the Db2 internal
    cast out task may miss a de-reference call to the DBD which
    it just referenced.  This missed de-reference call makes those
    DBD pages non-stealable and number of stealable page
    decreases.
    At the end, it resulted in DBD POOL FULL condition and
    DSNT500I message issued with REASON CODE RC00C90089
    RESOURCE TYPE 00000602.
    

Problem conclusion

  • Db2 code has been updated so that DBD pages
    will be marked stealable correctly.
    
    Keywords:
    MSGDSNT500I RC00C90089
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH14392

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-07-11

  • Closed date

    2019-09-17

  • Last modified date

    2019-11-01

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

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

    UI65348

Modules/Macros

  •    DSNIFPSC
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI65348

       UP19/10/02 P F910

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

Document Information

Modified date:
01 November 2019