EXPLAIN SQLSTMT specifications

This section describes the EXPLAIN SQLSTMT specifications.

Usage

Use this specification to investigate a particular SQL statement supplied in its text form.

Usage notes

  • The supplied SQL statement is explained by SQL EXPLAIN using a query number of 999735911. If this number already exists in the PLAN_TABLE of the job submitter, OMEGAMON for Db2 PE explain deletes the rows before processing the SQL statement. After successful execution of SQL EXPLAIN, the newly created rows in the PLAN_TABLE of the job submitter are used to produce the usual OMEGAMON for Db2 PE Explain report.

Syntax of the EXPLAIN SQLSTMT specification

Read syntax diagramSkip visual syntax diagramEXPLAIN SQLSTMT( explainable sql statement text ;)SSID1(DB2 subsystem id)SQLID(secondary authidUSER)LEVEL(DETAILBASICINDEXESKEYDISTSQLSUMMARYNORAWXPL)INDEX(YESNOALL)DEGREE(1ANYDSJESJ)
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.
explainable SQL statement text
Can span several lines.