2012 comes to an end today. Many have the day off, some don’t but aren’t getting much work done anyway, yet others still have things to complete to finish up their year. With all that in mind, I thought a short yet still handy post would be perfect to cap off the year.
Anyone who has ever messed around with tuning DB2 for z/OS has probably come across an IFCID (instrumentation facility component identifier) at one point or another. In fact, I did a blog post back in May 2010 discussing DSNWMSGS (Instrumentation Facility Component Identifier ) In fact, DB2’s IFCIDs have information on just about any DB2 for z/OS metric you could possibly be interested in, and new ones are added all the time and the current ones are always being expanded.
Continue reading »
Performance Availability Scalability
If you hang with DB2, what else do you want? What else could you ask for?
A few months back we (IBM) announced the DB2 Analytics Accelerator V2 (IBM United States Software Announcement 211-454, October 12, 2011) that combined all the things we’ve grown to love and expect from System z with the speed of Netezza. It was without a doubt the perfect marriage.. and almost everyone seems to want to hear more about it. This could be one of the hottest products I’ve seen come around it long time…… 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 »
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 it won’t be long until we hear something about End of Service (EoS) for DB2 9…… Continue reading »
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…… Continue reading »
On December 10, 2012 (that’s one year from now), DB2 9 will be withdrawn from marketing along with DB2 9 VUE and the DB2 9 Utility Suite…… Continue reading »
How many times have you had to listen to some old-timer (someone my age) tell you about the old days? I grew up in this business being told how we “used to do things”. It does get annoying sometimes. Old doesn’t always translate to better. For example, I can assure you that DB2 10 for z/OS performs better with far more functionality than let’s say DB2 Version 1.1…… Continue reading »
Are you on DB2 9 for z/OS? Are you using DB2′s trusted context? Are you also occasionally testing your disaster recovery plan? If you answered yes to all three of these questions, then here’s a little APAR that might be of interest to you….. Continue reading »
This afternoon I thought it would be fun to talk about a change in how parallelism affects your access path selection in DB2 9 for z/OS. Because of that change, we will also need to discuss a new DSNZPARM is being introduced by APAR PM16020 that throws some controls at how the optimizer makes that access path decision…. Continue reading »
The final topic of discussion is the table spaces that are defined in support of the sort work files. Let’s start with what is probably the number one question in my opinion. Should a sort work file be defined with secondary extents? I have always recommended, as have many others that I know, that you should NOT specify a secondary extent for any of the table spaces defined to DSNDB07 (or what ever your sort work database it’s called if you are a data sharing shop). Secondaries will work with sorts but why have sort do extra work processing multiple extents. It can’t possibly be good for performance…>>>> Continue reading »