I’m still talking about real-time statistics. This is what is referred to as the trickle affect. Periodically I keep discussing another little piece of real-time statistics. This stuff is important… it’s useful… and in my opinion it’s pretty interesting…. Every time I reread one of my posts, I think of something else I should have said.
Now it’s time to discuss managing index usage via real-time stats.
An interesting title for a blog post? The word “update” implies I have discussed real time statistic before; I have not. Although, I wish I had. In fact, it’s getting ever more difficult to come up with an original DB2 for z/OS subject to write about. It sometimes seems like everything has been done, been discussed, been explained; and at least a couple of times by now. This blogging stuff was so much easier when I had the only blog that covered DB2 for z/OS. Now there are a bunch of these blogs; they’re everyplace. Unfortunately, I must admit that a couple of them a pretty good. It’s difficult for me to write about something that someone else has already done a great job describing.
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.
Once again I was asked about DSNDB01.SPT01 compression in DB2 10. Some still remember a few commits made just as DB2 10 became generally available (GA) discussing how SPT01 compression wouldn’t be needed in DB2 10. Those first comments were based on the fact the a lot of the information in SPT01 was being moved to large objects (LOBs) and LOBs cannot be compressed. If SPT01 data was being stored in LOBs and LOBs can’t be compressed, there would be no need for compression.
The February 2013 product publication updates are now available. There were no updates for DB2 10 or DB2 9 for January 2013. The “almost new” tradition continues with the pub folk publishing documentation updates on a near monthly bases…..
Today’s blog post discusses two DSNZPARM keywords (MAXCONQN and MAXCONQW on the DSN6FAC macro) that were introduced on December 13, 2012 via APAR PM43293 
to improve management of (distributed) database access threads (DBATS). However, before we (that proverbial group of nonexistent people that live in my head that always tend to volunteer me for stuff that always seems to get me into trouble) get into the details of these two new system parameters, I thought it would be prudent to review a few of the existing distributed terms (like DBAT) and a few DSNZPARM keywords that are used in APAR PM43293’s cover and in today’s blog post: MAXDBAT and CONDBAT on the DSN6SYSP macro and CMTSTAT on the DSN6FAC macro.
The December 2012 product publication updates are now available. It looks like the DB2 Publication’s Team managed to get all of the most popular DB2 product publications (or at least the most popular in my opinion) updated just in time for the Holidays, just days before Christmas. The “almost new” tradition continues with the pub folk publishing documentation updates on an monthly bases…..
That’s right… I just didn’t care for the way it flowed… so I had a little time while eating lunch today… with a sandwich in one hand and keying with the other, I did a little patch work to a blog post I published back on October 28 that discussed the potential for wasting space in the older style table spaces after migrating to DB2 10.
Visit “APAR Friday: If you recently migrated to DB2 10, watch out for table spaces using too much space (HIPER) “ for the rewrite and what I think is a much better description of the issue. If you want, let me know if it reads better now.
November has been a quiet month for publication updates. So for this month only two have been updated in DB2 10 and two for DB2 9.
DB2 10 updates:
DB2 10 for z/OS Program Directory – GI10-8829-04 (403 KB PDF file)
(i1088294.pdf)
DB2 10 for z/OS VUE Program Directory – GI10-8839-04 (408 KB PDF file)
DB2 9 updates:
DB2 9 for z/OS Program Directory – GI10-8737-06 (175 KB PDF file)
DB2 9 for z/OS VUE Program Directory – GI10-8779-06 (181 KB PDF file)
All of the product documentation is available for download in PDF format from the DB2 product library web site . Check this site for updates before making major decision when using the manuals.
Finally, and maybe most importantly, the best place to get hold of the most up to date information about DB2 for z/OS, regardless of the release, will almost always be the Information Center on the web .
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. Plus, there will always be something entertaining posted every once in a while.
Willie Favero's Personal Website
Recent Comments