Recreating workload environments on other subsystems

You can generate and transfer to another DB2® for z/OS® subsystem a set of files for recreating the environment for a query workload on that subsystem. The files make it easy to reproduce the statistics, database objects, and settings for system parameters on the target subsystem.

Procedure

To generate and send this information to another DB2 for z/OS subsystem:

  1. Open either of the following locations in the workflow assistant for query tuning:
    • On the Manage and Tune Workloads page of the Manage section, select the query workload and click the Workload Environment Capture button above the table. You can generate files that describe the environment for the selected query workload.
    • On the left side of the Review section, after you run advisors and analysis tools on a query workload, click Capture Workload Environment. You can generate files that describe the environment for the current query workload.
  2. Select the Send the files to another subsystem or save them to your workstation only option and type a string of characters to use as a prefix for the generated files.
  3. Specify other report options that you might want to use.
  4. Specify the directory in which to generate the files on your workstation.
  5. Specify the FTP settings for the DB2 for z/OS subsystem where you plan to recreate the environment.
  6. Click Generate Report to generate the files.
  7. Click Upload Files.

What to do next

On the subsystem, carry out these steps:

The .zip file can be imported as a workload into another installation of the IBM® Data Studio client.


Feedback