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 either of these steps:
- On the Manage and Tune Workloads page
of the Manage section, select the query workload
and click the
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.
- 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.