Search

1 to 4 of 4
Sort by

Blog Entry
SQL Tuning for Developers – Part 2 Explain Output

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...

Tony Andrews's profile image

Blog Entry
Use Data Server Manager to tune your DB2 on z/OS Queries for Free

­­ 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...


Blog Entry
How to Avoid Dramatic Access Path Changes in DB2 for z/OS Dynamic SQL (or at Least Fix Them Quickly)

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...

Kurt Struyf's profile image

Blog Entry
Benchmarking Your SQL Tuning Decisions in DB2 for z/OS and LUW

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...