Creating query workloads
There are several ways to create query workloads.
Creating query workloads from SQL statements that are in a file
You can create a query workload from a list of SQL statements that is a text-based file.
Creating query workloads from XML files that use the Optim Query Workload Tuner schema
You can define query workloads in XML files that are written according to the Optim Query Workload Tuner schema and then create query workloads from those files in the workflow assistant.
Creating query workloads from SQL statements that are in statement caches
You can create query workloads from SQL statements that are in a dynamic statement cache.
Creating query workloads from SQL statements that are in catalog plans or packages
You can create query workloads from static SQL statements that are bound in a plan or package and stored in the DB2 catalog.
Creating query workloads from SQL statements that are in QMF
You can create query workloads from SQL statements from DB2 QMF™ for TSO/CICS.
Creating query workloads from SQL statements that are in QMF HPO
You can create query workloads from SQL statements from DB2 QMF HPO for TSO/CICS.
Creating query workloads from SQL statements that are in DB2 Query Monitor for z/OS
You can create query workloads from SQL statements that were offloaded from DB2 Query Monitor for z/OS into DB2 tables.
Creating query workloads from SQL statements that are in user-defined SQL repositories
You can create query workloads from SQL statements from DB2 for z/OS tables that a non-IBM query-monitoring application created and populated with the text of SQL statements, runtime metrics, and information about objects that the SQL statements reference.
Creating query workloads from SQL statements that are in SQL procedures
You can create query workloads from SQL statements that are in an SQL stored procedure.
Creating query workloads from the SQL editor
You can create a query workload from an SQL script that is open for editing in the SQL editor.
Creating query workloads from Optim Performance Manager
You can use Optim Query Workload Tuner to tune SQL statements that you are monitoring in Optim Performance Manager.
Creating a query workload as a subset of SQL statements in an existing query workload
You can create a query workload from a query workload that is already listed in the
Manage
section.
Related concepts
Testing packages of static SQL for performance regressions
Related tasks
General steps for tuning query workloads
Verifying the configuration of a subsystem for query-workload tuning
Importing query workloads from .zip files that the Optim Query Tuner client exported or from XML files
Collecting EXPLAIN information about the statements in query workloads
Getting recommendations for tuning query workloads
Generating table reports for query workloads
Sharing recommendations from the workload advisors
Running analysis tools and advisors on single SQL statements that are in query workloads
Adding SQL statements to query workloads
Consolidating EXPLAIN information for query workloads
Monitoring query workloads
Gathering information for IBM Support about the environments in which query workloads run
Recreating workload environments on other subsystems
Creating Query Tuner projects
Related reference
Workflow assistant for query tuning
Authorities and privileges required for analyzing and tuning query workloads
XML files that use the Optim Query Workload Tuner schema
Feedback