The Page Header

The explain page header is printed on every page of the Explain report.

For details on how to specify EXPLAIN PACKAGE commands refer to the Report Command Reference.

Explain - General Page Header

This sample shows the header of an Explain report, in its general form:

ACTUAL AT: 02/18/16 15:05:08  OMEGAMON XE DB2 PE (V5.4)   PAGE       : 1-1
                                   EXPLAIN PACKAGE        DB2 VERSION: V10
LOCATION : PMODA11                     DGO@TPG3           USER AUTHID: XRK
SUBSYSTEM: DA11                         DETAIL            CURR.SQLID : XRK

Field description

The header contains the following information, described in the order left block, middle block, right block:

ACTUAL AT

The date and time at which the DB2® subsystem (specified in SUBSYSTEM) containing explain functions, is accessed to collect the requested data.

LOCATION

The location name of the DB2 subsystem specified in SUBSYSTEM.

SUBSYSTEM

The ID of the DB2 subsystem that generated the data.

OMEGAMON® for Db2 PE (Vn)

The product name and version.

EXPLAIN

The object to be explained as specified in the EXPLAIN command (for example, QMFQUERY, PACKAGE, or PLAN).

<object type>

The name of the object to be explained as specified in the EXPLAIN command. It can have one of the following values:

SQL STATEMENT: None
QUERYNO: Query number
PLAN: Plan name, such as LARGEPLAN.
PACKAGE: Package ID
QMFQUERY: Unqualified QMF query name

<level>

The level of the report specified in the LEVEL subcommand option. Values are:

SUMMARY
SQL
BASIC
INDEX
DETAIL
NO RAW EXPLAIN DATA
KEY DISTRIBUTION

PAGE

The page number in the format lll-nnnn, where lll denotes the report number and nnnn the page number within the report.

DB2 VERSION

The version and release of the DB2 subsystem specified in SUBSYSTEM.

USER AUTHID

The user authorization ID.

CURR.SQLID

The current SQLID as specified in the SQLID option, or the default.