Getting the Most out of DB2 for z/OS and System z

How are you fixed for package space?

Mon, 09 Nov 2009 07:00:02 GMT

If you've migrated to DB2 9 recently, or even to DB2 Version 8, this may be a pretty serious question. After all we have had a few significant events that may have increased the number of packages that you maintain.

DB2 for z/OS Version 8 product publications have been refreshed (Oct 2009)

Sat, 07 Nov 2009 16:01:24 GMT

We (or maybe just me) spend so much time talk DB2 9 for z/OS, we often forget that we (IBM) still have customers running DB2 Version 8. With that in mind, I want to let all of my DB2 V8 friends know that 6 of your DB2 V8 product publications have been updated.

DB2 9 for z/OS product publications have been refreshed (Oct 2009)

Sat, 07 Nov 2009 15:26:33 GMT

DB2 land has stated on many occasions that you can always find the most current and up-to-date DB2 information in the web. Holding true to that statement, the entire DB2 9 for z/OS product library on the web has been updated as of October 2009. My thanks to Perry for catching the update and notifying me so I could make this post in a timely fashion.

What is DB2 Accounting Class 2 Not Accounted Time?

Mon, 02 Nov 2009 23:52:47 GMT

I'm not sure I have ever completely ripped off something already published... until now. The subject in the title is something I have considered writing about, just never got around to it. Now Technotes has a nice little piece on the subject.

APAR Friday: Fixing deferred close

Fri, 30 Oct 2009 02:00:02 GMT

Today's APAR has been around for a few months. However, I still thought it was worth mentioning because it can affect deferred close processing. Without this APAR applied there is that chance that CLOSED NO page sets could be closed by deferred close before CLOSE YES page sets.

DB2 X for z/OS technical preview

Thu, 29 Oct 2009 02:14:31 GMT

Are you interested in what might be around the corner for DB2 for z/OS? Wait no longer. Join Jeff Josten (Distinguished Engineer, DB2 for z/OS Development) for this 1 hour teleconference being held on November 3. You can join us at 11:00 AM Eastern Time, 10:00 AM Central Time, 8:00 AM Pacific Time, and 4:00 PM UTC.

How often do you refresh your warehouse tables?

Wed, 28 Oct 2009 17:02:59 GMT

I have another poll for you all. This one is pretty easy so no one should have any issues answering.

The saga of DB2's stored procedures continues: Part Trois

Mon, 26 Oct 2009 02:23:41 GMT

Shocker... part 3 of my series on stored procedures is finally getting posted. This is follow-on to my post on NUMTCB. For completeness, I wanted to review the other NUMTCB settings for the languages and situations we haven't discussed.

My last IOD post before the start of IOD

Sat, 24 Oct 2009 02:10:40 GMT

In a few hours I'll be boarding a plane for Las Vegas to attend IOD 2009. I know that a lot of you will not be making it this year. However, I also know that some of you will be attending. If you're there, please look me up. If you are at IOD and would like to talk about data warehousing on the mainframe, definitely let me know where we can meet up... breakfast, lunch, coffee... you name it, I'll be there.

APAR Friday: Error during index split

Fri, 23 Oct 2009 09:00:02 GMT

This one fixes a couple of problems with asymmetric index page split. It seems there could be an occasional issue and a possible inefficiency with page splitting in DB2 9. APAR PK62214 takes care of those issues.

Confession is good for the soul....

Thu, 22 Oct 2009 17:18:47 GMT

Or so they say. Just in case there is some truth to that old saying, I thought it would be fun to talk about travel mess-ups. Yes, today's post is going to be completely off topic, but it might be fun.

RSU0909 service package now available

Wed, 14 Oct 2009 12:14:45 GMT

Testing for RSU0909 is now complete. It contains all service through the end of June 2009 not already marked RSU along with PE resolution or HIPER/Security/Integrity/Pervasive PTFs and their associated requisites and supersedes through August 2009.

"Wash, Rinse, and Repeat"

Sun, 11 Oct 2009 15:29:48 GMT

While reading the back of the shampoo bottle, I realized that the instruction ask me to wash my hair forever. There seems to be no exit to the loop. Shouldn't it actually read "Wash, Rinse, Repeat until Clean"? And before I start to get e-mail, I'm guessing those are not actually the instructions on the back of the bottle. I have no way to check right now because I'm in a hotel and keep my shampoo in one of those magic bomb proof 3 oz bottles.

How to tune your buffer pools: a Redpaper

Sat, 10 Oct 2009 21:25:07 GMT

Last winter I asked about suggestions for future blogs post. One person e-mailed me that more "back to basic" stuff was needed. They felt explanations covering the fundamentals of DB2 had been ignored for the more fashionable topics. well, it seems IBM decided to fulfill their request with a new Redpaper about buffer pool tuning.

True continuous availability comes to DB2 LUW

Fri, 09 Oct 2009 11:15:04 GMT

Yes, it says DB2 LUW in the title of today's blog entry. That's because this is such a cool feature being announced today for LUW, that I thought it should get a mention here. DB2 pureScale on IBM Power Systems provides unlimited capacity, continuous availability, and application transparency. This is the kind of continuous availability that could only be achieve with DB2 for z/OS data sharing on System z.