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).