This screen provides data buffer pool I/O information for each
session attached to the DBEnvironment.
![[datases]](img/datases.gif)
To invoke the IO Data Session screen, use the d s command from the IO
subsystem, or use the /i d s command from other subsystems.
When you invoke this screen, its counters are set to zero.
Field Definitions |
 |
- REFRESH
The screen refresh rate, in seconds.
- SESSIONS
The number of DBEnvironment sessions.
- SORTIODATA
An indicator of how the sessions are sorted.
The sessions are sorted in descending order by the value
in the column indicated by the asterisk.
In the above example, sessions are sorted by their
DATA DISK WR values.
For more information, see the SET SORTIODATA command.
- CID
The DBEnvironment connection identification number.
- BUFF ACCESS
The number of page requests
the session has 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.
- MISS RATE
The percentage of pages that are not in the data buffer pool at request time. The percentage is calculated as follows:
MISS RATE = (DATA DISK RD / BUFF ACCESS) * 100
|
Related SET Commands |
|
The SET commands in the following table affect this screen.
| Command | Description | Example |
|---|
| SET REFRESH | Controls the refresh rate of the screen. | SET REFRESH 5 |
| SET SORTIODATA | Sorts sessions in descending order according to the value of the specified column. | SET SORTIODATA 2 |
| SET TOP | Limits the number of sessions displayed. | SET TOP 10 |
