Or should I use the term plan management, or maybe package management, plan stability, or even package stability? This feature has more names than a spy in an Ian Fleming novel. Of course, it doesn’t matter what you call it, the bottom line is this process has to be one of the coolest improvements to a plan or package since, well since forever. It allows for a fairly simply mechanism for getting back to a previous package. This is way beyond optimization hints (a somewhat misunderstood feature which may or may not do exactly what you think it really does every time you try to use it; but I digress)…… Continue reading »
Today’s post may not be new news to a lot of you; we have been talking about these new BIND/REBIND options for a while now. What IS new news is the APAR that delivers these new options closed on July 27. After the application of APAR PM25679, you can use everything in this post.
OK, so after a fairly vague opening paragraph, what in the world am I talking about?
As of July 27, the BIND and REBIND commands each have 3 very interesting new options; APCOMPARE, APREUSE, and EXPLAIN(ONLY)…. I covered EXPLAIN(ONLY) along with EXPLAIN PACKAGE (available in CM) and the EXPLAIN MODE special register (available in NFM) in a blog post back in January 2011 titled “DB2 10 is enhancing good old EXPLAIN: La deuxième tentative”…… Continue reading »
DB2 10 for z/OS is just loaded with little gems. Unfortunately, everyone likes to talk about the major enhancements and the more significant improvements; those are the type of things that get your presentation accepted for that conference you want to speak at…… Continue reading »