Chapter 13. Analysis of a problem workload 375
13.11 Comparing all three workload runs
To summarize the evolution of the performance of our workload, we provide a screen shot
after each run. The statements are sorted on the SQL statement text. This makes it easier to
compare the different runs because an individual statement is on the same row in each run.
Figure 13-35 shows the initial run.
Figure 13-35 Initial run with statements sorted by SQL statement text
Figure 13-36 shows the SQL statements after running Workload Statistics Advisor.
Figure 13-36 Run after Workload Statistics Advisor with statements sorted by SQL statement text

Get IBM DB2 9 for z/OS: New Tools for Query Optimization now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.