- REFRESH
The screen refresh rate, in seconds.
- SESSIONS
The number of DBEnvironment sessions.
- per sec
The scale used
to identify the length of the inverse video bars
and the data in the CUR, AVG, and MAX columns.
In the example above, the MAX frequency of
BUFF ACCESS is 20 per 1.0 second.
- BUFF ACCESS
The number of page requests
issued to the data buffer pool.
- DATA DISK RD
The number of pages
that are not in the data buffer pool
at request time.
The operating system must fetch these pages,
either from the operating system buffer pool or
by a physical disk read.
- DATA DISK WR
The number of dirty pages
from the data buffer pool
that were logically written to disk.
- LOG BUFF WR
The number of records written to the log buffer pool.
- LOG DISK RD
The number of log pages fetched from disk.
Unless you have used
rollforward recovery, this value is zero.
The operating system performs a physical read only if the log page
is not found in the operating system buffer pool.
- LOG DISK WR
The number of log pages written from the log buffer
pool to disk.
The operating system performs a physical write for
each log buffer write.
- CHECKPOINTS
The number of checkpoints taken. Checkpoints are
performed automatically, when the nonarchive log
becomes full, or
when you issue a CHECKPOINT command.
- DATA BUFFER MISS RATE
The percentage of pages
that are not in the data buffer pool at request time.
The percentage is calculated as follows:
DATA BUFFER MISS RATE = (DATA DISK RD / BUFF ACCESS) * 100
|
- TOTAL DATA BUFFER PAGES
The number of data buffer pages
configured. To change the number of data buffer pages, issue
the START DBE statement or the SQLUtil ALTDBE command.
- TOTAL LOG BUFFER PAGES
The number of log buffer pages
configured. To change the number of log buffer pages, issue
the START DBE statement or the SQLUtil ALTDBE command.
- ARCHIVE MODE
Either ON or OFF, to indicate archive
or nonarchive logging.