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
- If the SQL statement or query workload runs on a DB2 10 for z/OS
sub system, install the SYSPROC.ADMIN_INFO_SQL stored procedure and
ensure that you have the authority or privilege to run it. The Query
Tuner workflow assistant runs this stored procedure to gather information
about a statement’s environment. The stored proce dure then returns
the files with the information to the workflow assistant.
If the statement runs on a DB2 Version 9 for z/OS subsystem, you
have the option of using this stored procedure. If you don’t choose
this option, the workflow assistant itself gath ers the information
about the statement’s environment, adding more traffic to your network
than the stored procedure would.
- Collect
EXPLAIN information about the SQL statements that are in the query
workload.
- Contact IBM Support for
help troubleshooting the tuning process for the query workload.
- If IBM Support opens a PMR
for your request, obtain the PMR number.
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.