GLOBAL command with EXPLAIN option

This section describes the GLOBAL command with the EXPLAIN option.

Usage

Some OMEGAMON® 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

EXPLAIN Block
Read syntax diagramSkip visual syntax diagramSSID1(DB2 subsystem id)SQLID(secondary authidUSER)LEVEL(DETAILBASICINDEXESKEYDISTSQLSUMMARYNORAWXPL)INDEX(YESNOALL)OWNER(authidUSER)PLANEXPLAIN(K02EXPL)DEGREE(1ANYDSJESJ)
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.