Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Overview of workload comparisons

The Workload Access Path Compare component of the 

SQL Performance for DB2

solution identifies changed access paths in a user-defined workload.

Workload Access Path Compare analyzes SQL statements and provides reports that indicate specific differences between statements, including such things as differences in statistics, SQL text, and indexes that might have caused changes to the access paths.

Related topic

 Workload Access Path Compare component

The Workload Access Path Compare component makes it easy to define a workload, and then Extract and Explain the SQL text. Using the online interface, you can specify the source of the SQL statements and use qualifiers to define the workload through the creation of object sets.

The Workload Access Path Compare component can gather and compare workload data (including column distribution statistics and SQL text) from the following sources:

  • Apptune archived trace data sets
  • BMC AMI Performance
  • Db2 catalog
  • Statement cache
  • DBRM library
  • SQL text data set

After you define the workload, the Workload Access Path Compare component generates a job that Extracts and Explains the SQL. For each workload, the Workload Access Path Compare component saves the results in the following files that are registered in the hlq.REPOS repository. (hlq represents a workload high-level qualifier that you specify.)

  • hlq.SQLTXT.seqNumber contains the SQL text that the Extract process identifies.
  • hlq.OBJECT.seqNumber contains all objects and their statistics that the Explain process identifies.
  • hlq.PATH.seqNumber contains all access paths that the Explain process identifies.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*