Today’s blog post is a continuation of my earlier post on real time statistics (“An update on Real Time Statistics”) made just last week (March 21, 2013). Continuation is my way of saying I forgot to mention something that I really should have mentioned to make my real time statistics conversation more accurate. I didn’t discuss the relationship between DB2’s utilities and real time stats.

REORG, LOAD, REBUILD INDEX, COPY, RUNSTATS, and RECOVER all have an affect on real time statistics. REORG, LOAD, and REBUILD INDEX, all update numerous counters in SYSTABLESPACESTATS and SYSINDEXSPACESTATS; far too many to list here. However, check out the sub-heading “How utilities affect the real-time statistics” in Chapter 35 of the DB2 10 Managing Performance (SC19-2978) (link to InfoCenter equivalent) for a detailed list.

COPY and RUNSTATS do update a couple of columns in the real-time stats tables but more importantly, they both will externalize all in memory statistics when they are executed..

RECOVER to a current point in time has no affect on the real time statistics. However, a RECOVER to a prior point in time will cause all REORG, COPY, and STATS counters to be set to null.

It looks like my real-time statistics posts have become a series. In an effort to sort of “keep the post together”, I will list all real-time stats posts here:

P.S. OK, I've brought this silly post script thing back again… if you like this blog and find it informative, entertaining, or even useful, why not click on the subscription icon in the top right-hand corner (it looks a lot like ) so you are automatically notified of every post. Maybe you could even recommend this blog to a friend? Every reader I get helps…(smile)…

And, as usual, please remember: "These comments are my own personal opinions only and do not necessarily reflect the positions or opinions of my employer (IBM) or their affiliates. All comments are based upon my current knowledge and my own personal experiences. You should conduct independent tests to verify the validity of any statements made in this blog before basing any decisions upon those statements. In addition, any views or opinions expressed by visitors to this blog are theirs and do not necessarily reflect mine."

IBM, the IBM logo, ibm.com, [insert IBM brand that materials relate to ONLY IF it appears on our trademark Web site], and [insert IBM product name that materials relate to ONLY IF it appears on our trademark Web site] are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at “Copyright and trademark information” at www.ibm.com/legal/copytrade.shtml.

Disclaimer: Blog contents express the viewpoints of their independent authors and
are not reviewed for correctness or accuracy by
Toolbox for IT. Any opinions, comments, solutions or other commentary
expressed by blog authors are not endorsed or recommended by
Toolbox for IT
or any vendor. If you feel a blog entry is inappropriate,
click here to notify
Toolbox for IT.

Welcome to all things DB2 for z/OS. This is your one stop, your only stop, and your final stop to find out all you'll ever want to ...
more

Welcome to all things DB2 for z/OS. This is your one stop, your only stop, and your final stop to find out all you'll ever want to know about DB2 for z/OS. We'll be discussing how to upgrade to the latest DB2 version, have detailed "how it works" discussions, some performance tips, maintenance alerts, baby updates, with a few guest posts thrown in occasionally. In addition, you'll find all of the latest DB2 news and gossip, arrival notifications of the latest articles, books, seminars, and teleconferences, along with details on all of the major conferences. I'll occasionally be throwing in a post covering our z/OS operating system and our System z hardware. Plus, there will always be something entertaining posted every once in a while. This is the place you'll find just about anything you need to know to stay current with DB2 for z/OS, z/OS, or System z. This is also the place to get that little bit of lite reading each morning to start your day off on the right foot.
less

Receive the latest blog posts:

Share Your Perspective

Share your professional knowledge and experience with peers. Start a blog on Toolbox for IT today!

Statement About Content Ownership:The contents of this blog reflect my own personal opinions only and do not necessarily reflect the positions or opinions of my employer (IBM) or their affiliates. All content is based upon my current knowledge and my own personal experiences. You should conduct independent tests to verify the validity of any statements made in this blog before basing any decisions upon those statements. In addition, any views or opinions expressed by visitors to this blog are theirs and do not necessarily reflect mine.