If you have the files that contain the user data or query
workloads that were exported from your previous query-tuning tool,
you can use the client to import this data.
Before you begin
- Ensure that the product license is activated.
To import projects for workloads or workloads themselves into the
client, you must have a license for Optim Query
Workload Tuner for DB2® for z/OS®.
- If you import projects for workloads or workloads themselves into
the client, ensure that the following prerequisites are met:
Procedure
Follow one or more of the following sets of steps to
import the appropriate objects:
- To import a project:
- In the Optim Query
Tuner client,
click .
- In the Import window, expand Query
Tuner, and then click Projects.
- In the Select root directory field,
select the directory that contains the .zip file for the project.
- Select the project, and then click Finish. The project is imported into the Project Explorer.
- In the Project Explorer, expand the project and double-click
the node that is labeled No connection profile is bound
for the project.
- Specify the connection. In the window that opens, follow
either of these steps:
- If the project is for a single query, choose the connection to
the same data source that the project used in its original location
or choose the connection to a compatible data source.
- If the project is for a workload, choose the connection to the
same data source that the project used in its original location.
- Click OK.
- To import an SQL category or a filter:
- In the Optim Query
Tuner client,
click .
- In the Import window, expand Query
Tuner, and then click SQL Categories and Filters.
- In the Select root directory field,
select the directory that contains the .zip file for the SQL category
or the filter.
- Select the SQL category or filter, and then click Finish.
- To import a database connection profile, see Importing database connection information.
- To import a workload:
- Optional: Create a project to contain the
workload.
- In the Data Source Explorer,
right-click the subsystem, and then click to
open the workflow assistant for query tuning.
- Click Manage tab to open the
Manage and Tune Workloads page.
- Click Import Workload
at
the top of the page.
- In the File field, navigate to
and select the file for the exported workload.
- In the Workload name field, specify
a name for the workload.
- Click OK. The
workload is imported into the workload list.
- Optional: Put the imported workload in a
project:
- Select and right-click a workload group in the project that you
want to import the workload to, and then click Tune Workload.
- Select Attach to an existing workload,
and then select the imported workload from the Workload
name list.
- Click Finish.