Online Monitor EXPLAIN command
Use the EXPLAIN command to explain the currently executing SQL statement in the Thread Activity panels.
- SQL Statement and Package
- SQL Statement and DBRM
Note: If the Thread Detail panel has been modified to show the SQL
statement text, you can use the EXPLAIN command from the Thread Detail
panel as well.
If the explain request was successful, the DB2® Explain Output panel is displayed.
Note: EXPLAIN can be truncated to a minimum of EXP.
For a description of the Db2 Explain Output panel, see Explain output (Db2 Explain Output panel).