You can export query workloads from IBM® DB2® Optimization Expert for z/OS®.
Procedure
To export a workload from DB2 Optimization
Expert for z/OS:
- In the Project Navigator, double-click . The
View Workloads page opens.
- In the Subsystem Context section, select a subsystem from
the list and connect to the subsystem.
- In the workload list, select the workload to export.
- Click the arrow on the New Workload button
and click Export.
- Specify the amount of information for the exported workload
to contain.
- In the File field, type the path
and name for the file to contain the workload. The extension must
be .zip.
- Click OK.
Results
The exported workload is stored in a compressed file that
you can import later.