PM24723: IFCID 225 REAL STORAGE STATISTICS ENHANCEMENTS IFCID225

Obtain the fix for this APAR.

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 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.