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


1  EXPLAIN PLAN  (
2.1 planname
1 )
1? SSID(1)(
2.1 DB2 subsystem id
1)? SQLID(
2.1 secondary authid
2.1 USER
1)? LEVEL(
2.1! DETAIL
2.1 BASIC
2.1 INDEXES
2.1 KEYDIST
2.1 SQL
2.1 SUMMARY
2.1 NORAWXPL
1)?  INDEX (
2.1! YES
2.1 NO
2.1 ALL
1 )?  HOSTVAR (
2.1! NO
2.1 YES
1 )?  ACCTYPE (
2.1! ALL
2.1 MATCHING
2.1 NONMATCH
2.1 TABSCAN
1 )?  TABLE (
2.1 authid.
2.1 tabname
2.1 tabnam*
1 )?  DBRM (
2.1 name
2.1 nam*
1 )?  FIRST (
2.1! 1
2.1 n
1 )?  LAST (
2.1! 9999999
2.1 n
1 )?  PACKAGES (
2.1! YES
2.1 NO
2.1 ALL
1 )?  PACKLIMIT (
2.1! 100
2.1 n
1 )?  GEN (
2.1! 1
2.1 n
1 )?  FORMAT (
2.1! YES
2.1 NO
1 )?  LOCATION (
2.1 location name
1 )
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.