Gathering information about the environments in which SQL statements run on DB2 for z/OS

When you are working with IBM® Support to resolve a problem with tuning an SQL statement, or when you want to recreate the environment of an SQL statement on a different DB2® for z/OS® subsystem, you can capture the statement's environment in a set of files. You can then upload the files to IBM Support or to the other subsystem.

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:


Feedback