DB2 EXPLAIN report

The DB2® EXPLAIN report is available through the Application Performance Analyzer ISPF interface only, and is displayed by typing the command “EX” on a SQL statement. It is available in most DB2 reports. There are two sources of information for this report: static EXPLAIN data and dynamic EXPLAIN data.