EXPLAIN PACKAGE specifications

This section describes the EXPLAIN PACKAGE specifications.

Usage

Use this specification to investigate all or selected SQL statements for given packages.

Usage notes

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

Syntax of the EXPLAIN PACKAGE specification


1  EXPLAIN
PACKAGE
2  (
3.1 location name.
3.1 collection id
3.1 coll*
3.1 *
2 .
3.1 package id
3.1 pack*
3.1 *
3.1 .(version id)
3.1 .(vers*)
3.1 .(*)
3.1 .(-n)
2 )
2?  SSID(1) (
3.1 DB2 subsystem id
2 )
2?  SQLID (
3.1 secondary authid
3.1 USER
2 )
2?  LEVEL (
3.1! DETAIL
3.1 BASIC
3.1 INDEXES
3.1 KEYDIST
3.1 SQL
3.1 SUMMARY
3.1 NORAWXPL
2 )
2?  INDEX (
3.1! YES
3.1 NO
3.1 ALL
2 )
2?  HOSTVAR (
3.1! NO
3.1 YES
2 )
2?  ACCTYPE (
3.1! ALL
3.1 MATCHING
3.1 NONMATCH
3.1 TABSCAN
2 )
2?  TABLE (
3.1 authid.
3.1 tabname
3.1 tabnam*
2 )
2?  FIRST (
3.1! 1
3.1 n
2 )
2?  LAST (
3.1! 9999999
3.1 n
2 )
2?  GEN (
3.1! 1
3.1 n
2 )
2?  FORCE (
3.1! NO
3.1 YES
2 )
2?  FORMAT (
3.1! YES
3.1 NO
2 )
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.
collection id
package id
version id
Identify the package that statements are to be explained for.

The asterisk is allowed as wildcard character for collection id, package id, and version id.

The version id string can contain the following special characters: underscore (_), at (@), number (#), dollar ($), dash (–), and period (.).

Use -n (the version generation number preceded by a minus sign) to specify the version id. The version generation number is the line counter of a package list sorted by the precompile date in descending order. The newest package version has the generation number "0" and the oldest package version has the generation number "-n".