order by rows_accessed desc fetch first 5 rows only"

Table 9 3 lists the more commonly used snapshot table functions. A complete list 

and detailed descriptions of snapshot table functions can be found in the 

System 

Monitor Guide and Reference, 

SC09 4847.

Table 9 3   Common snapshot table functions

Snapshot table function

Information returned

SNAPSHOT_DBM

Database manager information

SNAPSHOT_DATABASE

Database information. Information is returned only if 

there is at least one application connected to the 

database.

SNAPSHOT_APPL

General application information for each application that 

is connected to the database on the partition. This 

includes cumulative counters, status information, and the 

most recent SQL statement executed (if the statement 

monitor switch is set).

SNAPSHOT_APPL_INFO

General application identification information for each 

application that is connected to the database on the 

partition.

SNAPSHOT_LOCKWAIT

Application information regarding lock waits for the 

applications connected to the database on the partition.

SNAPSHOT_STATEMENT

Application information regarding statements for the 

applications connected to the database on the partition. 

This includes the most recent SQL statement executed (if 

the statement monitor switch is set).

SNAPSHOT_TABLE

Table activity information for each table that was 

accessed by an application connected to the database. 

Requires the table monitor switch.

SNAPSHOT_LOCK

Lock information at the database level, and application 

level for each application connected to the database. 

Requires the lock monitor switch.

SNAPSHOT_TBS

Information about table space activity at the database 

level, the application level for each application connected 

to the database, and the table space level for each table 

space that has been accessed by an application 

connected to the database. Requires the buffer pool 

monitor switch.

SNAPSHOT_BP

Buffer pool activity counters for the specified database. 

Requires the buffer pool monitor switch.

 Chapter 9. Testing and tuning 

291