Use this report to see information from PLAN_TABLE built by a DB2® EXPLAIN request for a particular SQL statement. Each report line represents a row in the result PLAN_TABLE. You obtain this report by issuing an "EX" line command against the SQL statement you want explained. Application Performance Analyzer will issue a dynamic EXPLAIN request on the SQL text of the statement you have selected.
Not all SQL statements can be the subject of a dynamic EXPLAIN request. Included among these are UPDATE or DELETE statements with a WHERE CURRENT OF clause.
A prerequisite for this report is activation of the DB2+ option during the measurement.
The EXPLAIN request is executed at the time you request it. It is not issued at the time of the measurement. Thus any changes made to the DB2 objects since the measurement was requested will affect the EXPLAIN request. It is valid to select a DECLARE CURSOR or a SELECT INTO statement for EXPLAIN. Application Performance Analyzer will remove the DECLARE CURSOR clause or the INTO clause before issuing the dynamic EXPLAIN. Application Performance Analyzer will also substitute any :H host variable placeholders in static SQL statements with a question mark. Application Performance Analyzer can issue EXPLAIN on SQL statements up to 15000 bytes long.
[ Top of Page | Previous Page | Next Page | Contents | Index ]