You can use several of the features of InfoSphere®
Optim™ Query Workload Tuner for DB2 for z/OS, Version 4.1.1
without the need to work through the IBM® Data Studio client.
By calling web APIs that are accessible through a new tuning service, you can use these features:
- Format SQL statements for better readability and annotate their predicates with statistics
- Generate access plan graphs, so that you can examine visual representations of access plans
- Create query workloads, which are groups of SQL statements that are related to each other, such
as all SQL statements for a particular application
- Explain query workloads
- Delete query workloads
- Compare EXPLAIN snapshots (EXPLAIN information generated at particular points in time) for the
SQL statements in a single query workload or for two query workloads, and return a report of the
comparison
- Generate a report of index recommendations for query workloads and an analysis of the indexes
that are used by the query workload
You can run these features automatically through scripts or applications that you create to run
at intervals or on command. You can even run them in a host environment, eliminating the need to
connect to your DB2® for z/OS® subsystems from the Data Studio client on a Windows or Linux workstation.
For documentation about how to use the tuning service, as well as sample code, contact IBM
Support.