Skip to Content

Default language.

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.

You can access these views from the EZSCACHE view (see the following figure).

Related topic

Application-analysis-views

>W1 EZSCACHE==========B1DEFG===*========DDMMMYYYY==10:30:37====MVDB2====D====1=====
                                                      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

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Ops Monitor for Db2 13.1