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.