Dynamic EXPLAIN
A dynamic EXPLAIN is requested when an “EX” command is issued on
a SQL statement that does not have static EXPLAIN data available. Application Performance Analyzer will
issue a dynamic EXPLAIN request on the SQL text of the statement you
have selected.
Note: 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 dynamic 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 dynamic EXPLAIN request. It is valid to select a DECLARE CURSOR or a SELECT INTO statement. Application Performance Analyzer will remove the DECLARE CURSOR clause or the INTO clause before issuing the dynamic EXPLAIN request. It will also substitute any :H host variable placeholders in static SQL statements with a question mark. A dynamic EXPLAIN request can be requested on SQL statements up to 15000 bytes long.