PM24723: IFCID 225 REAL STORAGE STATISTICS ENHANCEMENTS IFCID225

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • IFCID 225 real storage statistics enhancements.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 users.                               *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1. Real storage monitoring is critical  *
    *                      for system stability. DB2 private,      *
    *                      shared, and common above the bar        *
    *                      real storage consumption was            *
    *                      previously unreported.                  *
    *                                                              *
    *                      2. An ABEND04E RC00F9000C in CSECT      *
    *                      DSN9SCNP could occur if a -DISPLAY      *
    *                      TRACE(*) SCOPE(GROUP) command was       *
    *                      issued.                                 *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Enhancements to DB2 are required.
    

Problem conclusion

Temporary fix

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

Comments

  • 1. The following real storage monitoring and management
    enhancements are introduced:
    
     a. IFCID225 is enhanced with new fields
    
        QW0225PriStg_Real
        QW0225PriStg_Aux
        QW0225ShrStg_Real
        QW0225ShrStg_Aux
        QW0225ShrStkStg_Real
        QW0225ShrStkStg_Aux
        QW0225ComStg_Real
        QW0225ComStg_Aux
    
        to track real and auxiliary storage consumption
        for the private, shared, and common above the bar
        storage objects.  In addition, field
    
        QW0225PT
    
        is added to track the number of active parallel
        child threads at the time the IFCID225 is written.
    
        Please refer to external mapping macro DSNDQW03
        for field offsets and full descriptions.
    
     b. IFCID1 data section 9 mapped by external
        mapping macro DSNDQSST is enhanced to include field
    
        QSST_CONTSTOR_NUM
    
        This field will record the number of 31-bit agent
        local pools contracted due to system configuration
        parameter CONTSTOR being enabled.
    
     c. Real storage consumption for a given DB2 subsystem
        can now be controlled via 2 system configuration
        parameters. These system configuration parameters
        require PM37647 to be fully enabled.
    
        REALSTORAGE_MANAGEMENT
    
        This parameter will tell DB2 how to manage
        real frames that are backed but are not being
        used by the system. With this parameter set to
        ON, unused backed real frames will be discarded
        when possible. When this parameter is set to
        OFF, DB2 will only unback unused frames when
        critical real storage or auxiliary storage usage
        is detected.  When this parameter is set to AUTO,
        DB2 will unback unused frames when the system
        begins to page. The default for this parameter
        is AUTO.
    
        New messages DSNV516I and DSNV517I will be
        written when DB2 enters and exits real storage
        contraction mode as controlled by
        REALSTORAGE_MANAGEMENT.
    
    
        REALSTORAGE_MAX
    
        This parameter will bound this DB2 subsystem
        to the amount of GB of real and auxiliary storage
        specified in this parameter.  DB2 will terminate
        if this threshold is reached.
    
        New message DSNS003I will be written when DB2
        approaches the threshold specified by
        REALSTORAGE_MAX.  New message DSNS004I will be
        written to indicate relief from this condition.
    
    2. -DISPLAY TRACE output may be split into multiple
    multi-line write to operator messages (MLWTO)
    to prevent an ABEND04E RC00F9000C in CSECT DSN9SCNP.
    If output is split, a new message DSNW198I will
    be written to flag the end of a MLWTO message. A
    new message DSNW199I will be written to mark the
    beginning of the related MLWTO message.
    

APAR Information

  • APAR number

    PM24723

  • 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

    2010-10-18

  • Closed date

    2011-06-09

  • Last modified date

    2011-07-05

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

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

    UK68652

Modules/Macros

  •    DSNDCT   DSNDGPVT DSNDLPVT DSNDQSST DSNDQW02
    DSNDQW03 DSNDRMFT DSNDTAB  DSNDWWCB DSNLTMSC DSNSCON  DSNSCON2
    DSNSCTL  DSNSDMPS DSNSDSTK DSNSENFL DSNSEOM  DSNSFACL DSNSHDWN
    DSNSLD1  DSNSLD2  DSNSPURS DSNSSET  DSNSSTUP DSNSTKGA DSNSTKGG
    DSNSVSPC DSNTAC2  DSNTXSTB DSNVAI   DSNVDTMS DSNVEUS2 DSNVFACE
    DSNVMON  DSNVRMEG DSNVRMEL DSNVTEB  DSNWDFSM DSNWVCM1 DSNWVCM2
    HDBAA10J
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK68652

       UP11/06/28 P F106

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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM24723

Modified date:

2011-07-05

Translate my page

Machine Translation

Content navigation