Tuning of SQL queries requires understanding why DB2 chose a particular access path and determining whether or not that access path should perform as expected. The key to this is understanding what filter factors are, how they are used by the Optimizer and how to get DB2 to better estimate them ...
Let’s start this discussion candidly – I am a big fan of the FETCH FIRST n ROWS ONLY clause coded in a SQL statement. That assertion will require some clarification, since there are some valid use cases, and others that make little sense. Regardless, I will try not to over-complicate the...
One of the selling points of DB2 10.5 and the Columnar options is that existing row-based tables can be converted to column-based tables and will be accessed by DB2 seamlessly and with no extra effort from the DBA. All well and good, and the performance should be much better, but what if it’s...
By Kurt Struyf, Lone Star Consulting This article is based on a recent tuning engagement at a customer site and describes the countermeasures that were enacted to restore system performance. Those countermeasures include a daily process to establish an access path baseline and sample jobs...
DB2 11 significantly improves query performance and database administration through enhancements to catalog statistics and optimization profiles. Statistics collection have been improved in DB2 11 to make them easier to use and maintain. Their capabilities have also been extended to collect...
EU13A08.pdf
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. Check it out...
Potential SQL Performance Improvements in DB2 11 for z/OS By Daniel L Luksetich, IDUG DB2 11 White Paper Editorial Committee As with any new release of DB2 for z/OS there comes a host of SQL performance improvements. Some of these you get straight away, some with a bind or next prepare...
Our performance thread continues this month with another IDUG Tech Talk webinar. Query tuning is an essential piece to the database performance puzzle. While the database engine on either DB2 platform does a good job of access path selection, there are still situations where a DBA or developer...
In this presentation John Hornibrook takes viewers into a deep dive into the workings of the DB2 optimizer.
6e0r5g725m3855.flv