Whether you’re considering a bit of spring cleaning on your existing indexes or suiting up for hunting season, the evolutionary improvements in DB2 10.1 and 10.5 provide DBAs with a game-changing set of index management options.
The third and final of three presentations donated to IDUG by Sheryl Larsen is now available for download in the IDUG content file library. This presentation is from her DB2 10 & 11 SQL Optimization Enhancements IDUG presentation.
Terry Purcell of the IBM SVL Optimization Team recorded his IDUG presentation introducing the query optimization enhancements that were delivered with DB2 10 for z/OS. Terry goes into detail of each enhancement and explains when each optimization improvement can and will be applied.
As with any new release of DB2 for z/OS there comes a host of SQL performance improvements. In this article, Dan Luksetich outlines a few interesting SQL enhancements coming our way in DB2 11 for z/OS.
Our performance thread continues this month with another IDUG Tech Talk webinar. Listen to David Simpson of Themis Inc. introduce us to query tuning with IBM Data Studio.