EXPLAIN PLAN specifications

This section describes the EXPLAIN PLAN specifications.

Usage

Use this specification if you want to investigate all or selected SQL statements in a given plan. You can specify the name of the plan to be explained.

Usage notes

  • OMEGAMON for Db2 PE EXPLAIN verifies that the specified plan exists in the catalog table SYSIBM.SYSPLAN.
  • If it does, OMEGAMON for Db2 PE EXPLAIN further verifies that the plan has been bound with the EXPLAIN(YES) option.

Syntax of the EXPLAIN PLAN specification

Read syntax diagramSkip visual syntax diagramEXPLAIN PLAN ( planname )SSID1(DB2 subsystem id)SQLID(secondary authidUSER)LEVEL(DETAILBASICINDEXESKEYDISTSQLSUMMARYNORAWXPL)INDEX(YESNOALL)HOSTVAR(NOYES)ACCTYPE(ALLMATCHINGNONMATCHTABSCAN)TABLE(authid.tabnametabnam*)DBRM(namenam*)FIRST(1n)LAST(9999999n)PACKAGES(YESNOALL)PACKLIMIT(100n)GEN(1n)FORMAT(YESNO)LOCATION(location name)
Notes:
  • 1 SSID is required unless specified in a preceding GLOBAL command.

Subcommand options

Note: This section only explains specific subcommands. The other subcommands and options are described in Subcommands and options. The following list gives additional or specific descriptions of selected options, where appropriate.
planname
Identifies the plan that statements are to be explained for.