DB2 Version 9.7 for Linux, UNIX, and Windows
Explain routines
EXPLAIN_GET_MSGS table function
The EXPLAIN_GET_MSGS table function queries the EXPLAIN_DIAGNOSTIC and EXPLAIN_DIAGNOSTIC_DATA Explain tables, and returns formatted messages.
EXPLAIN_FORMAT_STATS scalar function
EXPLAIN_FROM_ACTIVITY procedure - Explain statement using activity event monitor information
The EXPLAIN_FROM_ACTIVITY procedure explains a specific execution of a statement using the contents of the section obtained from an activity event monitor.
EXPLAIN_FROM_CATALOG procedure - Explain a statement using section information from catalogs
The EXPLAIN_FROM_CATALOG procedure explains a statement using the contents of the section obtained from the catalogs. The Explain output is placed in the Explain tables for processing using any existing explain tools (for example,
db2exfmt
).
EXPLAIN_FROM_DATA procedure - Explain a statement using the input section
The EXPLAIN_FROM_DATA procedure explains a statement using the contents of the input section. The Explain output is placed in the Explain tables for processing using any existing Explain tools (for example,
db2exfmt
).
EXPLAIN_FROM_SECTION procedure - Explain a statement using package cache or package cache event monitor information
The EXPLAIN_FROM_SECTION procedure explains a statement using the contents of the section obtained from the package cache or from the package cache event monitor. The Explain output is placed in the Explain tables for processing using any existing explain tools (for example,
db2exfmt
).
Parent topic:
Supported system-defined SQL routines and views