IBM® Optim™ Query Workload Tuner for DB2® for z/OS® provides
query workload monitoring and analysis tools.
IBM Optim Query Workload Tuner for DB2 for z/OS enables
you to view, capture and analyze query workloads that run on DB2 for z/OS data
servers. When the license for IBM Optim Query Workload Tuner for DB2 for z/OS is
activated on a data server, all advanced query tuning features are
enabled in the query tuner client, in addition to the following workload
tuning activities:
- Creating monitor profiles to capture information about the performance
SQL statements and query workloads that run on the data server
- Defining and capturing query workloads
- Getting expert advice, considering an entire workload, in the
following areas:
- Statistics
- Index design
- Query design
- Capturing and sending detailed information about workload environments
to different data servers or IBM software
support.
- Creating detailed reports about tables that are referenced by
SQL statements in the workloads.
For documentation about the Data Mart advisor, new in version 2.2.1,
see http://www-01.ibm.com/support/docview.wss?uid=swg27019567.