Gathering information for IBM Support about the environments for query workloads

You can send IBM® Support files that give details about the environment in which a query workload runs. These files can help IBM Support to troubleshoot problems that you are having while tuning the SQL statement.

Before you begin

About this task

The tools for collecting information about the environment generate a set of files that you upload to an FTP server that IBM Support uses.

Procedure

To generate and send this information, open either of the following locations in the Query Tuner Workflow Assistant:

  1. Follow one of these steps:
    • In the Data Source Explorer, expand the connection to the DB2® for z/OS® subsystem that the SQL statement runs on. Then, right-click the subsystem and select Analyze and Tune > Capture Environment > Capture Workload Environment.
    • On the Manage and Tune Workloads page of the Manage section, select the query workload. Then, in the More actions field, select Capture Workload Environment.
    • On the left side of the Review section, after you run advisors and analysis tools on a query workload, click Capture Workload Environment.
  2. Select the Send the files to IBM Support option and type the PMR number.
  3. Specify other report options that you might want to use.
  4. Specify the FTP settings that IBM Support provided to you.
  5. Click Generate Report to generate the files.
  6. Add any other files that IBM Support asked you to provide.
  7. Click Upload Files.

Feedback