Creating Query Tuner sample projects

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:

  1. Click File > New > Query Tuner Sample Project.
  2. Specify a name for the sample project.
  3. 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®.
  4. 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.
  5. 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.

Feedback