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.
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:
- 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 .
- 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.
- Select the Send the files to IBM Support option
and type the PMR number.
- Specify other report options that you might want to use.
- Specify the FTP settings that IBM Support
provided to you.
- Click Generate Report to generate
the files.
- Add any other files that IBM Support
asked you to provide.
- Click Upload Files.