.
Static SQL Cache
The Static SQL Cache views display statistics related to SQL statements that currently exist in the Db2 static SQL cache. The information is extracted from IFCID 401 records available in Db2 Version 10 and later releases.
You can access these views from the EZSCACHE view (see the following figure).
Static SQL Cache Menu
SQL Statement List Views............. +----------------------+
. SQL List by Time Cached............ | Place cursor on |
. SQL Execution Statistics by Package | menu item and |
. SQL Wait Time Totals by Package.... | press ENTER |
. SQL List (To Customize)............ +----------------------+
You can set filters to limit the amount of data displayed. These are accessed by hyperlinks on the views described in Static SQL Cache views. The following filters can be set:
- None
- Synchronous buffer reads
- Executions
- GETPAGEs
- Index scans
- Parallel groups
- Rows processed
- Rows examined
- Sorts
- Tablespace scans
- Buffer writes
- RID failures due to limit reached
- RID failures due to storage shortage
View name | Type | Description |
|---|---|---|
SSSQL | Tabular | List of SQL statements currently in static SQL cache |
SSWAITS | Tabular | Wait times per package and SQL statement |
SSSTATS | Tabular | Static SQL Statement statistics |
SSSTATSD | Detail | Detail statistics for a specific statement in the Static SQL Cache |
SSTEXT | Tabular | SQL text for a selected statement This is an internal view and will only be used in hyperlinks from other Static SQL Cache views. |
SSLIST | Tabular | A view, which can be customized, of all elements available for a Static SQL Statement in the cache |
Related topic