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…… Continue reading »
The three APARS we are focusing on this virtual Friday are all marked as HIPER (High Impact or Pervasive APAR). HIPERs should be given serious consideration and applied in a timely fashion. Only the most critical fixes are marked as HIPER…… Continue reading »
On September 21, IBM will be presenting a no-charge Webcast “TCO news: Optimizer in DB2 10 for z/OS Beta” featuring optimization expert Terry Purcell. Here’s an opportunity to find out what the enhancements and additions to DB2′s optimizer in DB2 10 will do for you.
Wouldn’t it be nice if you could just prototype an index and not have to go through the overhead of creating a new index, all just to find out if the optimizer might decide to use it? Guess what? You can. As of DB2 9 for z/OS (and back fitted into DB2 Version 8 via APAR PK46687 ), virtual indexes are now available for your use…. Continue reading »