Explain

Use this option to examine the access path method chosen by DB2® for a given SQL statement in an easy-to-read format. The SQL statement you want to explain can be an existing entry in a specific PLAN_TABLE, an SQL statement from a previously bound plan or package, or a dynamically entered SQL statement.

You can view detailed information about packages, DBRMs, tables, indexes, and the SQL text. The SQL statement can be modified for online tuning.

You can also explain an SQL statement from within the thread activity function to explain a currently executing SQL statement, or from within an ISPF/PDF editor to explain an SQL statement imbedded in a source program or SPUFI input.

See Monitoring the access path with Explain for more information.