Introduction In Db2 the best way for any developer writing SQL queries to know how a query is gathering the data for a result set is through the Db2 explain tool. I find too many developers do not know what to do or where to start when it comes to SQL tuning, program tuning, or application...
IBM® Data Server Manager is an integrated database management tools platform for DB2® for z/OS databases. It was designed to be simple to set up, easy to use, and enterprise ready with the ability to manage hundreds of databases. Data Server Manager Base Edition offers database...
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...
By Daniel L. Luksetich, DanL Database Consulting - SQL tuning is not just looking at an SQL statement and EXPLAIN information, but is also about verifying whether or not a tuning change, be it a change to a statement or change to a database object, actually has a positive impact on...
1 Comment - no search term matches found in comments.