IBM 000-8697 Manual Do Utilizador

IBM Informix OnLine Database Server Administrator’s Guide

Use the -p option to display profile counts.

The first portion of the display describes reads and writes.

Reads and writes are tabulated in three categories: from disk, from buffers,
and number of pages (read or written).

The first

%cached

 field is a measure of the number of reads from buffers

compared to reads from disk. The second

%cached

 field is a measure of the

number of writes to buffers compared to writes to disk.

OnLine buffers information and writes to the disk in pages. For this reason,
the number of disk writes displayed as

dskwrits

 is usually less than the

number of writes executed by an individual user.

dskreads

is the number of actual reads from disk.

pagreads

is the number of pages read.

bufreads

is the number of reads from shared memory.

%cached

is the percent of reads cached, calculated as
100 * (bufreads - dskreads)/bufreads.

dskwrits

is the actual number of physical writes to disk.

pagwrits

is the number of pages written.

bufwrits

is the number of writes to shared memory.

%cached

is the percent of writes cached, calculated as
100 * (bufwrits - dskwrits)/bufwrits.