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.
Updated: 3 hours 30 min ago
A new DB2 clock has started: End of Service for DB2 9
(Posted February 7, 2012) ThatÂ’s right. If youÂ’ve been keeping score you know that we had already announced End of Marketing (EoM) for DB2 9 last year. That happens on December 10, 2012. When I discussed that date in this blog I did mention that ...
The question: Would You Like More WLM Information In DB2 Accounting Trace
(Posted February 7, 2012) ThatÂ’s the question. However, itÂ’s not my question. ItÂ’s the question that a friend of mine, Martin Packer, put to his readers in his blog today. ItÂ’s a legitimate question and its a question of interest to me as well. In Martins blog...
Let's talk about EXPLAIN and how it uses the QUERYNO column
(Posted February 6, 2012) The last time I checked there were still 17 tables currently used by EXPLAIN (as described in my Feb 16, 2010 post “Explaining the history of EXPLAIN tables”). I hope that hasn’t gone up again sine I last checked... (smile)... Besides a...
APAR Friday 2: A HIPER closed for RECOVER
(Posted February 3, 2012) I know I already did an “APAR Friday” post for today, that’s why the title has a 2 in it. The other reason for a second post is that I came across something interesting tonight. I try to scan as many closed APARs as possible to find bet...
APAR Friday: HIPER - Potential optimization problem using frequency, histogram statistics
(Posted February 3, 2012) Although gathering frequency and histogram statistics can in some cases be a performance life saver, it seems there are occasions that those same frequency and histogram statistics can also get you into to trouble in the from of a not too good access path being chosen. APAR PM54681 could remedy the situation.
A somewhat new parm for workload manager (WLM)
(Posted February 1, 2012) Way back on March 16, 2011 an APAR closed that impacted how many WLM environment address spaces WLM would choose to start or leave started. traditionally WLM will decide when to start and when to stop one of its environment address spaces. ...
DB2 10, DB2 9, and DB2 V8 Product Documentation has been refreshed for January 2012
(Posted January 31, 2012) With each new month, we are almost always getting a few of the product publications refreshed. That trend has continued into the new year. For January, all the active releases of DB2 are getting a little something new...
Complimentary DB2 for z/OS seminars in a city near you
(Posted January 31, 2012) IBM is offering complimentary DB2 for z/OS seminars in many cities this quarter. There are limited places so register ASAP and secure your place today.
Make sure you are register for this excellent upcoming February Webcast
(Posted January 31, 2012) DB2 for z/OS Version 8 goes out of SERVICE (End of Service) on April 20, 2012, just three months from now. DB2 10 once again offers a skip level migration from DB2 Version 8 to DB2 10. DB2 9 for z/OS has announced its END of MARKETING as of De...
Looking for a good technical book? Have you checked out what's available from Roger E. Sanders?
(Posted January 30, 2012) Have you been cruising the web of late looking for a book to read before taking one of the DB2 LUW certification test? If you have, one of the names that I am sure came up is Roger E. Sanders. With that intro begins our second of what I h...
Are you planning to order DB2 10 for z/OS in the near future? If yes, you are definitely going to want to read this
(Posted January 29, 2012) I came across something today that I was going to say was new, however, it may only be new to me.... itÂ’s a PDF file of cumulative ++HOLD data that must be applied to DB2 10. This is pretty cool. This PDF has all the actions that must be ...
APAR Friday: A few HIPERs to help bring January 2012 to a close
(Posted January 28, 2012) In an effort to bring you meaningful and current information that hopefully can you both time and aggravation, and in an effort to differentiate my blogs from the others on the Internet (remember when there was just one DB2 for z/OS blog running arou...
The 2011 Master the Mainframe Contest has come to a conclusion
(Posted January 27, 2012) And the results keep right on improving... we have a very smart kids out there with good futures in the world of computers should they choose to go the direction. To paraphrase Darth Vader (Star Wars): “The Mainframe is strong with this g...
The "2012 DB2's GOT TALENT Contest" is almost here! Have you entered?
(Posted January 26, 2012) Have you ever been listening to a presenter at a conference or user group meeting thinking to yourself “I could do that”. Well, here’s your chance to let the world (or at least the Db2 community) that YES you really can that. ...
Be careful how you define your partition-by-growth universal table space
(Posted January 25, 2012) I recently had a conversation with a friend about the additional work they may have made for themselves by misinterpreting one sentence for a keyword when they creating a whole pile of their partition-by-growth universal table space. I looked...
January 2012 (RSU1112) service package is tested and available
(Posted January 25, 2012) Testing for the latest service package RSU1112 (3rd Quarter 2011) is complete. This addendum contains PE resolution or HIPER/Security/Integrity/Pervasive PTFs and their associated requisites and supersedes through November 2011.
Well worth a second mention: DB2 9 withdraw from marketing
(Posted January 24, 2012) On December 10, 2012 (thatÂ’s less than one year from now), DB2 9 will be withdrawn from marketing along with DB2 9 VUE and the DB2 9 Utility Suite.
Twas the night before Christmas, when all through the house.....
(Posted December 23, 2011) Not a creature was stirring... well actually, everyone what stirring; who could possibly sleep with everything that was going... Televisions blaring, banging in the kitchen, cars going by out front, peopleÂ’s smart phones and cell phones b...
Looking for a good technical book? Have you checked out what's available from Paul Zikopoulos?
(Posted December 22, 2011) Many of you will recognize PaulÂ’s name. YouÂ’ve seen it on books (I have a few of his books on my bookshelf), Redbooks, articles, and on the speaker list for most conferences that involve information management and IBM. HeÂ’s another one of...
Read any good books lately; technical books that is... (smile)....
(Posted December 21, 2011) At some point in time, people have actually asked me that question. I would always answer “No”. After I was sure they were appropriately shocked, I would add “Nothing that isn’t technical, that is”.