>>---SQLCACHE_SNAPSHOT-----------------------------------------><
The schema is SYSFUN.
The SQLCACHE_SNAPSHOT returns the the results of a snapshot of the db2 dynamic sql statement cache.
The function does not take any arguments.
It returns a table as listed below. Refer to System Monitor Guide and Reference for details on the columns.
Table 17. Column names and data types of the table returned by SQLCACHE_SNAPSHOT table function
| Column name | Data type |
|---|---|
| NUM_EXECUTIONS | INTEGER |
| NUM_COMPILATIONS | INTEGER |
| PREP_TIME_WORST | INTEGER |
| PREP_TIME_BEST | INTEGER |
| INT_ROWS_DELETED | INTEGER |
| INT_ROWS_INSERTED | INTEGER |
| ROWS_READ | INTEGER |
| INT_ROWS_UPDATED | INTEGER |
| ROWS_WRITE | INTEGER |
| STMT_SORTS | INTEGER |
| TOTAL_EXEC_TIME_S | INTEGER |
| TOTAL_EXEC_TIME_MS | INTEGER |
| TOT_U_CPU_TIME_S | INTEGER |
| TOT_U_CPU_TIME_MS | INTEGER |
| TOT_S_CPU_TIME_S | INTEGER |
| TOT_S_CPU_TIME_MS | INTEGER |
| DB_NAME | VARCHAR(8) |
| STMT_TEXT | CLOB(64K) |