SQL Guide : Diagnostics and troubleshooting for SQL : Observing performance
  
Observing performance
You can use the SQL Info facility to provide information about an SQL statement and the SQL statement EXPLAIN PLAN FOR to show the execution graph that the SQL optimizer selected for a given SQL statement. Typically, if you need to contact UNICOM Systems, Inc. Support, you will be asked to provide the SQL statement, EXPLAIN PLAN output, and SQL Info output from the EXPLAIN PLAN run with info level 8 for more extensive trace output.
See also
SQL Info facility
EXPLAIN PLAN FOR statement
Diagnostics and troubleshooting for SQL