A fix is available
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.
[{"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:
05 July 2011