The number of different compilations for
a specific SQL
statement.
Table 1. Snapshot
Monitoring Information| Snapshot Level |
Logical Data Grouping |
Monitor
Switch |
|---|
| Dynamic SQL |
dynsql |
Basic |
- 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 num_executions
to determine whether a bad compilation environment may be skewing
the results of dynamic SQL snapshot statistics.
DB2 Version 9.7 for Linux, UNIX, and Windows