Snapshot Level Statement |
Logical Data Grouping dynsql |
Monitor Switch Basic |
Resettable |
Yes |
|
Element Name Element Type |
num_compilations counter |
Description: The number of different compilations for a specific SQL statement.
Usage: Some SQL statements issued on different schemas, such as "select t1 from foo" will appear to be the same statement in the DB2 cache even though they refer to different access plans. Use this value in conjunction with "Statement Executions" to determine whether a bad compilation environment may be skewing the results of dynamic SQL snapshot statistics.