In this comprehensive overview of DB2 10, for z/OS Lori Ann Galluzzo goes through the features of DB2 10 in great detail. Each feature is discussed, along with how and when to take advantage of the feature, as well as some pitfalls and things to watch out for.
We use Explain to find out the access path for a query. Jim Dee, from BMC shows you how you can compare the access path with previous versions of the query or package – comparing the estimated costs, and identifying those that have changed with a rebind.
There are often multiple ways to code a query, some of which perform better than others. It is not just a matter of effectively utilizing the indexes, but also the SQL constructs. This week, Tony Andrews of Themis, and a popular speaker, author, consultant and trainer is writing on this topic.
DB2 11 for z/OS is here, and IDUG has the first user review in our DB2 11 for z/OS user technical perspective white paper.
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.