(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 ...

(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...

An approach to scheduling a report which can be delivered to users on multiple, non-recurring dates using an IBM Cognos Event Studio agent.

This document is intended to provide a single point of reference for techniques and product behaviours when dealing with the Dynamic Query Mode delivered with IBM Cognos 10.

(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...

(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...

Were you able to join today’s DB2 Night Show webinar?  Today was the start of this year’s very popular competition.  If you missed it, I strongly encourage you to watch the replay .  Here’s what you’ll get:   Contestant 1- Richard How to Find all DB2... 0 0 110

(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.

Crysta Anderson’s latest blog entry is a must read:  Top Books for your MDM Library .  She’s mentioned several books that I know very well and also recommend.  Her post reminded me that I met author Larry Dubov at IOD last year when he was promoting his... 0 0 156

Transactional logic that works across heterogeneous databases needs to use global transactions. The IBM Data Server Provider for .NET supports the distributed transaction model from the System.Transactions namespace, which has the capability to create and manage global transactions. The code examples in this article show how to use the IBM Data Server Provider for .NET to create and manage global transactions on the IBM data servers.

Encoding in mainframes is EBCDIC, and encoding in distributed system is ASCII. Mainframe computers need to communicate with distributed systems that include Microsoft Windows, UNIX, and other platforms. The EBCDIC and ASCII code page conversion happens in each communication between the IBM z/OS operating system and the distributed system. However, some characters cannot go round trip between EBCDIC and ASCII in some non-English languages. As a result, the application doesn't work correctly. One solution is to modify application code, but that is often complicated and time consuming. This article presents a light-weight solution as an alternative. No application code change is needed, and you can resolve the issue quickly.

It seems funny to write a “welcome to my blog” entry after blogging for so many years!  I’m sure I did such an entry when I first started my blog in 2005.  I know that I’ve written welcome-type entries after inviting many people at a conference to read... 0 0 156

(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.&#160...

(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...

(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.

(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...

  The initial response to DB2 10 has been extremely positive. An early adopter of DB2 10 said, “ We could not have been more thrilled with all the performance improvements! There is definitely gold in this version and you don’t even need to spend time to find... 0 0 352

(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...

(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 ...

(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...