I'm looking to obtain the CPU usage and I/O usage for a query prior to
execution. The output from Visual Explain gives me exactly what I
want, however, I want to be able to do this on the fly (ie. not via
the control center). Suggestions?

Wendy Powley
School of Computing
Queen's University
Kingston, ON

On Mon, 14 Nov 2011 07:44:42 -0800, Wendy wrote:

Look at the EXPLAIN SQL statement (SQL Ref Vol 2 manual). After you run the EXLAIN, you will need to
run db2exfmt (Explain table format command in Command Reference manual) to see the output.

Thank you! I see now where the information is in the db2exfmt
output. Thanks so much.

Wendy