Testing for the forth service pack of 2013, RSU service package RSU1304, is now complete. This May 2013 1st Quarter quarterly report First Addendum contains all service through the end of December 2012 not already marked RSU. This service also includes PE resolution and HIPER/Security/Integrity/Pervasive PTFs and their associated requisites and supersedes through March 2013.
DB2 10 for z/OS is just loaded with little gems. So many so, that sometimes I just mess up their descriptions. That’s what happened during my IDUG presentation today on a DB2 10 EXPLAIN feature. I took two very cool concepts delivered by DB2 10 and reversed their descriptions: EXPLAIN (ONLY) and EXPLAIN PACKAGE. Thanks to the two folks that were in my session today who caught my attempted confusion.
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.
“Red Alerts” are serious and should be address in as timely manner as possible.
In this case, it all has to do with the ability to recover spacemap updates, are rather not be able to recover them.
Testing for the second service pack of 2013, RSU service package RSU1302, is now complete. This March 2013 4th Quarter quarterly report is the second addendum of 2013. It is based on the previous quarter and contains PE resolution and HIPER/Security/Integrity/Pervasive PTFs and their associated requisites and supersedes through January 2013.
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…..
Have you ever wondered exactly what some of the system parameters (or DSNZPARM keywords) actually do for you (or to you)? Some are so straightforward, just looking at the keyword gives away all you need to know. However, there are some, even after research their meaning can still sometimes elude you. And that’s assuming you can even find their description (as in some DSNZPARM keywords delivered via the maintenance stream). It’s those DSNZPARM keywords I want to talk about today. Or rather, the kind I want to hear from you about today.