Jun 20

This may be the shortest blog post I have ever published.

What aspects of EXPLAIN would you all like to see discussed here?   Yes, I am looking for ideas for new materials..  and who better to ask than the people who make this blog possible.

Post your suggestions/questions here as comments or send them directly to me at wfavero@acm.org.

Thanks and looking forward to your comments…

Share
Tagged with:
Jun 10

Yup, I’m “flying the Friendly Skies”*** once again.I’m finally getting the opportunity, good or bad, to get out in front of folks once again…  Over the next two weeks I will be speaking at…. Continue reading »

Share
Tagged with:
Mar 27

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 »

Share
Tagged with:
Feb 07

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)…… Continue reading »

Share
Tagged with:
Jan 14

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 »

Share
Tagged with:
Jul 31

New, cool, and simple to use… What else could you ask for? Oh, not enough, you want even more… How about, it will make your life as a DB2 DBA or DB2 security administrator simpler and more productive. Just how, you might ask? I’ll tell you how….. Continue reading »

Share
Tagged with:
preload preload preload