Gathering information for IBM Support about the environments for query workloads that run on DB2 for z/OS

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 workflow assistant for query tuning:

  1. Follow either of these steps:
    • 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 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