Support for collection of more accurate real storage usage statistics

by Akiko Hoshikawa and Judy Tobias

In Db2 11 for z/OS and Db2 12 for z/OS, we introduce an enhancement that improves your ability to obtain accurate real storage usage statistics. In the past, z/OS capacity planners have experienced difficulties in determining an accurate estimate of the main memory that their Db2 subsystems used. With this enhancement, you can have more confidence that you are acquiring the appropriate amount of main memory for your Db2 environment.

When you enable this enhancement, Db2 writes new fields in IFCID 225 trace records during the first statistics interval after midnight each day. Those fields contain the number of discarded pages that are eligible for page steal. You can use those statistics in conjunction with existing real storage usage fields to calculate accurate storage usage. By examining daily storage statistics for multiple weeks, you can discover trends in your real storage usage.


You might see a performance impact during the time that the new statistics are collected. For that reason, this enhancement is not automatically enabled when you apply the associated PTF. To avoid unexpected side effects, you might want to enable this enhancement in collaboration with IBM Software Support.


Related information

Base release enhancements after the DB2 12 initial release (see "Support for collection of more accurate real storage usage statistics")

Views: 214

Add a Comment

You need to be a member of The World of DB2 to add comments!

Join The World of DB2

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.


Db2 12 Migration Planning & Customer Experiences - Part 1

Started by Sandy Flippen in What's hot ? on Thursday. 0 Replies

Register Now! NEXT CONTENT! Upcoming double webcast Db2 12 Migration Planning and customer experiences. Live Q &A session! PART 1 24th Sept 11:00 AM EST PART 2…Continue

IBM Db2 Analytics Accelerator Workshop

Started by Sandy Flippen in What's hot ? on Tuesday. 0 Replies

IBM Db2 Analytics Accelerator WorkshopPeter Bendel and Ute BaumbachWhen: Thursday, Oct 24, 2019 14:00 to 17:00Where: TBD Price: FREELIMITED PLACES AVAILABLE PLEASE REGISTER ASAP ALLOCATED ON FIRST COME BASISAbstract:Join this complimentary workshop…Continue

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service