Testing for the eleventh service pack for 2013, RSU service package RSU1311, is now complete. This December 2013 3rd Quarter Quarterly Report (2nd addendum) (57.6 KB PDF file) contains ALL service through the end of June 2013 not already marked RSU. This service also includes PE resolution and HIPER/Security/Integrity/Pervasive PTFs and their associated requisites and supersedes through October 2013.
I’m doing something a little different today… I’m actually publishing an APAR Friday post on Friday. I have the day of off for the Thanksgiving holiday here in the USA, I can’t eat any more (one of the ways of showing thanks on Thanksgiving is to eat yourself into a coma), and don’t feel like shopping (it’s Black Friday here in the US, if you are not in/from the US, it’s hard to explain), so I thought I would do a little blogging to close out the month. An APAR Friday post for the last post of November seemed appropriate.
Just when you thought it was safe to go back into the water, err I mean back into my blog, up pops yet another subsystem parameter write-up… (smile)….
Whenever I have to do work on a system that is primarily dynamic SQL or lots of distributed activity, I will often check out what SAP recommends that DB2’s subsystem parameters be set. Yes,m you should tailor you subsystem parameters to how you expect your workload to perform. However, occasionally, having a “starting point” can come in very handy. The suggested SAP subsystem parameters is just hat “starting point” for me.
Testing for the seventh service pack of 2013, RSU service package RSU1310, is now complete. This October 2013 1st addendum to 3rd Quarter Quarterly Report (62 KB PDF file) contains ALL service through the end of June 2013 not already marked RSU. This service also includes PE resolution and HIPER/Security/Integrity/Pervasive PTFs and their associated requisites and supersedes through September 2013.
Today’s stroll through the wonderful world of subsystem parameters (AKA DSNZPARMs) will have us examine changes to how two DDF related subsystem parameters resulting in the APAR being marked as HIPER, a new subsystem parameter adding a control for real time statistics collected by the environmental descriptor manager (EDM), an adjustment to PLANMGMTSCOPE, and a change to the defaults used by a utility.
It’s been a while since I’ve had an APAR Friday post… and yes, I do know it’s not Friday… it’s a theme thing I’m trying to get going… LOL
So what’s up in my mixed up bag of interesting fixes that have arrived over the last month? Quite a few actually.
I know you’re going to find this so hard to believe (you should be imagining sarcasm in my voice right now!!!) but I found yet another subsystem parameter topic to discuss. My trio of post are not even a day old and already there’s more… And today’s post also fits perfectly into the APAR Friday theme… (smile)…
This will be short. I just want to make you aware of a couple of HIPERs that have been delivered over the last two months. Yes, a few of these are old, but a few are brand new. They are all important. By definition a HIPER is an APAR fix that should be given extremely serious consideration about applying to your DB2. They should not be ignored. At the very least they should be reviewed and the impact to your DB2 should be evaluated for what ever they are correcting.
In keeping with my subsystem parameters discussions (AKA: DSNZPARMs), I came across an APAR that fits the theme perfectly. It also goes well with all the whining I do about being careful taking defaults.
APAR PM90893 will change the default value of IX_TB_PART_CONV_EXCLUDE to YES. That means that today, if you take the current default (NO), DB2 does not exclude trailing columns from the partitioning key when it converts to table-controlled partitioning. Having a lot of columns that are unnecessary for partitioning could potentially be a performance issue.
Testing for the eighth service pack for 2013, RSU service package RSU1308, is now complete. This August 2013 2nd Quarter Quarterly Report (2nd addendum) (64.1 KB PDF file) contains ALL service through the end of March 2013 not already marked RSU. This service also includes PE resolution and HIPER/Security/Integrity/Pervasive PTFs and their associated requisites and supersedes through July 2013.