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.

The command syntax is:
Figure 1. Syntax of the EXPLAIN command
Read syntax diagramSkip visual syntax diagram EXPLAIN
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).