IO Data Program Screen

The screen refresh rate, in seconds.

The number of DBEnvironment sessions.

An indicator of how the programs are sorted. The programs are sorted in descending order by the value in the column marked with the asterisk. In the example above, the programs are sorted by the DATA DISK WR values. For more information, see the SET SORTIODATA command.

The HP-UX process identification number of the DBEnvironment session.

The number of page requests the session has issued to the data buffer pool.

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.

The number of dirty pages from the data buffer pool that have been logically written to disk.

The percentage of pages that are not in the data buffer pool, calculated as follows:

   MISS RATE = (DATA DISK RD / BUFF ACCESS) * 100

The name of the program being run, usually the parent process of the process actually connected to the DBEnvironment.

All of the sessions running a program are listed beneath the PROGRAM NAME.

For a given column, the average amount of work performed by the processes in the list.

Each program has a list of processes beneath it. Each process has a line of information, which shows percentages in each column. The line shows the exact percentages of work each process performs, in each column. The AVERAGE field, however, shows the average amount of work each process performs.

For example, in the above screen, process 18371, which is running the program ISQL, is responsible for 76% of the BUFF ACCESS activity in the DBEnvironment. Process 18381 is responsible for 24% of the BUFF ACCESS activity. On average, each process is responsible for 50% of the BUFF ACCESS activity.