Well, it’s been a good run… but all good things must come to an end.
DB2 Universal Database for z/OS Version 8 (5625-DB2), DB2 UDB for z/OS Version 8, or more conveniently DB2 V8 first peeked out at us on January 31, 2003 when the beta program began and arrived full force on the world when it went generally available (GA) on March 26, 2004…… Continue reading »
It was close; we’re almost out of April. However, the crew that keeps all that DB2 for z/OS documentation up to date slipped in an April refresh of the product publications just under the wire keeping up the newly established tradition of publishing documentation updates on an almost monthly bases….. Continue reading »
If you are interested in improving the performance of your partition REORGs, here’s a code update that should be of interest. All you need to do is stay current on your maintenance and add an additional keyword here and there. Magically, you have better performance…… Continue reading »
Based on a question we received, it was decided that an additional polling question should be created. This question has to do with copying statistics from production to your test system rather than running RUNSTATS on you test system. Unfortunately, what could be some of the most interesting information is difficult to solicit in a poll……. Continue reading »
RUNSTATS is important; I think we can all agree on that. However, how it SHOULD be used and how it’s actually used is still a huge point of discussion. What is extremely cool is that we will get answers to the first part, the “how it SHOULD be used”, from Pat Bossman, an STSM with IBM Silicon Valley Lab’s DB2 for z/OS Query Optimization team. Pat has offered to respond to any of your RUNSTATS inquiries that you post here. This is quite the opportunity for you to get answers to all of those RUNSTATS questions that have been on your mind from an EXPERT on the subject. For the second half of the question, “how it’s actually used”, we’ll attempt to answer by continuing the use of the polling questions to gather RUNSTATS usage information…….. Continue reading »
First one; a DB2 supplied stored procedure could flood your dynamic statement cache with SQL. If you rely on the statement cache to minimize dynamic bind times, this one could be a biggie… after all, the statement cache is a wrap around buffer. When all the space is used up, it just writes over stuff already in the cache. You’re not going to get very good reuse if something goes a little off an fill the cache on you…… Continue reading »
I have an opportunity to bring in an extremely knowledgeable person from IBM Silicon Valley Lab to talk to us about Data Studio V3.
Some of you may only know that Data Studio is a no-charge download available from IBM. However, do you know how very power Data Studio is? This is not one of those “you get what you pay for” stories…… Continue reading »
DB2 comes in two favors, one for z/OS and the other for LUW (Linux, UNIX and Windows). this blog focuses on DB2 for z/OS… at least most of the time. However, there are those times when the LUW side does something so very cool, I have to make mention of it.
In a press release that went live when April 3, 2011 arrived, IBM is letting the world know about DB2 10 and InfoSphere Warehouse 10. The first planned availability for DB2 10 for LUW is April 30, 2012…… Continue reading »
DB2 10 has been great for my DSNZPARM presentation. There were so many new ZPARM keywords delivered with the DB2 10 base release and even more new DSNZPARM keywords showing up in APARs since general release (GA). Today, we’ll discuss one more ZPARM arriving via APAR…… Continue reading »