Dynamic SQL—optimization
---------------- -------- --------
REOPTIMIZATION 0.00 0
PREP_STMT_MATCH 0.00 0
PREP_STMT_NO_MATCH 0.00 0
IMPLCIT_PREPARES 0.00 0
PREP_FROM_CACHE 0.00 0
CACHE_LIMIT_EXCEED 0.00 0
PREP_STMT_PURGED 0.00 0
--------------------------
REOPTIMIZATION
NOT FOUND IN CACHE
FOUND IN CACHE
IMPLICIT PREPARES
PREPARES AVOIDED
CACHE LIMIT EXCEEDED
PREP STMT PURGED
ROWS FETCHED
ROWS INSERTED
ROWS UPDATED
ROWS DELETED
DB2 PARSE STATEMENTS
DB2 REPLACE STMT
DB2 MATCHING REUS
DB2 CREATE DUPLICATE
The following table describes the fields in the Dynamic SQL (optimization) section:
Field | Description |
|---|---|
REOPTIMIZATION | Number of times reoptimization occurred for a query (QXSTREOP) |
PREP_STMT_MATCH | Number of times Db2 satisfied a PREPARE request by making a copy of a statement in the prepared statement cache (QXSTFND) |
PREP_STMT_NO_MATCH | Number of times Db2 searched the prepared statement cache but could not find a suitable prepared statement (QXSTNFND) |
IMPLCIT_PREPARES | Number of times Db2 did an implicit PREPARE for a statement bound with KEEPDYNAMIC(YES) because the prepared statement cache did not contain a valid copy of the prepared statement (QXSTIPRP) |
PREP_FROM_CACHE | Number of times Db2 did not prepare a statement bound with KEEPDYNAMIC(YES) because the prepared statement cache contained a valid copy of the prepared statement (QXSTNPRP) |
CACHE_LIMIT_EXCEED | Number of times Db2 discarded a prepared statement from the prepared statement cache because the number of prepared statements in the cache exceeded the value of subsystem parameter MAXKEEPD (QXSTDEXP) |
PREP_STMT_PURGED | Number of times Db2 discarded a prepared statement from the prepared statement cache because a program executed a DROP, ALTER, or REVOKE statement against a dependent object (QXSTDINV) |
Field | Description |
|---|---|
REOPTIMIZATION | Number of times reoptimization occurred for a query (QXSTREOP) |
NOT FOUND IN CACHE | Number of times Db2 searched the prepared statement cache but could not find a suitable prepared statement (QXSTNFND) |
FOUND IN CACHE | Number of times Db2 satisfied a PREPARE request by making a copy of a statement in the prepared statement cache (QXSTFND) |
IMPLICIT PREPARES | Number of times Db2 did an implicit PREPARE for a statement bound with KEEPDYNAMIC(YES) because the prepared statement cache did not contain a valid copy of the prepared statement (QXSTIPRP) |
PREPARES AVOIDED | |
CACHE LIMIT EXCEEDED | Number of times Db2 discarded a prepared statement from the prepared statement cache because the number of prepared statements in the cache exceeded the value of subsystem parameter MAXKEEPD (QXSTDEXP) |
PREP STMT PURGED | Number of times Db2 discarded a prepared statement from the prepared statement cache because a program executed a DROP, ALTER, or REVOKE statement against a dependent object (QXSTDINV) |
ROWS FETCHED | Number of rows fetched (QXRWSFETCHD) |
ROWS INSERTED | Number of rows inserted (QXRWSINSRTD) |
ROWS UPDATED | Number of rows updated (QXRWSUPDTD) |
ROWS DELETED | Number of rows deleted (QXRWSDELETD) |
DB2 PARSE STATEMENTS | |
DB2 REPLACE STMT | |
DB2 MATCHING REUS | |
DB2 CREATE DUPLICATE |