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.
This is the second of three presentations donated to IDUG by Sheryl Larsen. This presentation is from her Tuning SQL for Performance seminar, and contains information about advanced SQL programming and performance.
This is the first of three presentations donated to IDUG by Sheryl Larsen. This presentation is from her Advanced SQL Coding seminar, and contains information about advanced SQL programming and performance.
With large tablespaces, well designed NPIs can improve query performance but can create performance and availability challenges. DPSIs can help, but have their own compromises. In this article, Toine Michielse provides an overview of some DPSI-related enhancements coming in DB2 11 for z/OS.
Within a few months we’ll have DB2 11 for z/OS, which contains some important enhancements to DB2’s pureXML feature. In this article, Isaac Yassin takes a look back at DB2’s previous XML support before previewing some of the new features introduced in DB2 11.