Description
Online program
This program generates detailed statistics for accesses to the SQL-DBbuffer (caches). All values are calculated since the last DB restart.

Precondition
Call transaction ST04
Menu: Goto -> Activity -> Current statistics -> Cache statistics

Output

• Accesses:

Total number of accesses

• Successful:

Number of successful accesses

• Failed:

Number of failed accesses

• Hit Rate %:

Hit rate in %
The individual buffers have the following functions:

• Data:

Data buffer

• File Directory:

Buffer for file handling

• ISM:

Buffer for incremental store management

• PSM:

Buffer for page store management

• USM:

Buffer for user store management

• Log:

Buffer for the log area

• Catalog:

Catalog buffer

• Temporary:

Session-specific buffer