Capturing SQL statements that you want to analyze and tune
To
capture
an SQL statement means to specify the statement that you want to tune. You can capture SQL statements from a large number of locations.
Typing SQL statements to analyze and tune
You can type or paste an SQL statement directly in the workflow assistant for query tuning.
Capturing SQL statements from the SQL editor
You can capture SQL statements that you are writing or editing in the SQL editor.
Capturing SQL statements from the routine editor
You can capture SQL statements that you are writing or editing in the routine editor.
Capturing SQL statements from files
You can capture SQL statements from text-based files.
Capturing SQL statements from SQL categories
You can capture SQL statements from SQL categories that you created in the
SQL Category
view.
Capturing SQL statements from exported workloads
If you are using DB2 for z/OS, you can capture SQL statements that are in a query workload that was authored directly in an XML file.
Capturing SQL statements that run on DB2 for z/OS
With the workflow assistant for query tuning, you can capture SQL statements from a number of different locations in DB2 for z/OS or a z/OS subsystem.
Capturing SQL statements that run on DB2 for Linux, UNIX, and Windows
With the workflow assistant for query tuning, you can capture SQL statements from several different locations in DB2 for Linux, UNIX, and Windows.
Capturing SQL statements from Optim Performance Manager
You can tune SQL statements that you are monitoring in Optim™ Performance Manager.
Feedback