This grouping of routines and views can be used to retrieve
information about the access plan that the optimizer chooses for an
SQL statement or XQuery statement.
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
This scalar function is used to display formatted statistics
information which is parsed and extracted from explain snapshot captured
for a given query.
DB2 10.5 for Linux, UNIX, and Windows