Importing query workloads from XML files

You can create a query workload that runs on DB2® for z/OS® from a query workload that was exported from the IBM® Data Studio client or from a query workload that is defined in an XML file that is written in the InfoSphere® Optim™ Query Workload Tuner schema.

Before you begin

Procedure

To import a query workload:

  1. Click the Manage tab.
  2. In the Manage and Tune Workloads page of the Manage section, click the Import Workload. After you specify the XML file to import, a new workload is listed in the table on the Manage and Tune Workloads page.

What to do next

Collect EXPLAIN information about the SQL statements that are in the query workload.

Feedback