GLOBAL command with EXPLAIN option

This section describes the GLOBAL command with the EXPLAIN option.

Usage

Some OMEGAMON® XE for DB2® PE Explain options can be made globally valid, if specified in the GLOBAL command. An option value specified in a specific EXPLAIN command takes precedence over the corresponding GLOBAL option value.

Syntax of the GLOBAL EXPLAIN options

Read syntax diagramSkip visual syntax diagramEXPLAIN Block:
 
          (1)
|--+-SSID-------(--DB2 subsystem id--)-+------------------------|
   +-SQLID--(--+-secondary authid-+--)-+
   |           '-USER-------------'    |
   |           .-DETAIL---.            |
   +-LEVEL--(--+-BASIC----+--)---------+
   |           +-INDEXES--+            |
   |           +-KEYDIST--+            |
   |           +-SQL------+            |
   |           +-SUMMARY--+            |
   |           '-NORAWXPL-'            |
   |           .-YES-.                 |
   +-INDEX--(--+-NO--+--)--------------+
   |           '-ALL-'                 |
   +-OWNER--(--+-authid-+--)-----------+
   |           '-USER---'              |
   |                 .-K02EXPL-.       |
   +-PLANEXPLAIN--(--+---------+--)----+
   |            .-1---.                |
   '-DEGREE--(--+-ANY-+--)-------------'
                +-DSJ-+
                '-ESJ-'

Notes:
  1. SSID is required unless specified in a preceding GLOBAL command.

Subcommand options

The syntax diagram shows the options that are available with this subcommand. See Subcommands and options for comprehensive descriptions of these options.