You can create and use
a sample project to learn about
how to tune SQL statements and workloads with the client without a
connection to an actual data server. Because the samples do not use
a real data server connection, some functions are disabled. However,
the sample projects are pre-populated with example SQL statements,
workloads, and analysis and tuning results.
Procedure
To create
a sample Query Tuner project:
- Click .
- Specify
a name for the sample project.
- Select a type
for the project. You can create
a sample project for either DB2® for Linux®, UNIX®, and Windows® or DB2 for z/OS®.
- Select a query or a workload from the list. The
selected query or workload and the associated analysis and tuning
results will be loaded when the sample project is created.
- Click Finish to create the sample
project.
Results
The sample project is created.
The Project Explorer is refreshed
and displays the new sample project. Because the data server connection
is unavailable for the sample project, any actions that require an
actual data server connection are disabled. Similarly, no items can
be deleted from or added to the sample project. You can, however,
delete the sample project.
What to do next
You can expand the sample
project in the Project Explorer
to review the query and the analysis and tuning results. To open the
pre-populated analysis and tuning results for a workload, open the
Run Workload Advisors page of the workflow assistant and click
Run
All Advisors.