Provides current I/O statistics for an active database.

Syntax

proutil db-name -C iostats

Parameters

db-name

Specifies the active database where you are running database I/O statistics.

The statistics provided by PROUTIL IOSTATS include buffered, unbuffered, and logical I/O database operations. The statistics are cumulative from database startup, or from the last time the statistics were cleared with PROUTIL ZEROSTATS. For more information resetting the statistics, see PROUTIL ZEROSTATS qualifier.

Example

The following output is a sample display of PROUTIL IOSTATS:

Database name is sports (2524)
FILE          BUFFERED        UNBUFFERED          LOGICAL (2556)
            Writes  Reads    Writes  Reads   Reads  Writes  Extends (2557)
==========================================================================
sports.b1       0      0        317    389     388     252        2
sports.d1       1    173         11      0     171      11        0
sports_7.d1   773   6792          0      0    6790     772        0
sports_7.d2   270   1702         10      0    1701     269        4
sports_8.d1   649    715          0      0     713     648        0
sports_8.d2     1      1          0      0       0       0        0
sports_9.d1     1      2          0      0       0       0        0
sports_9.d2     1      1          0      0       0       0        0
sports_10.d1    1      2          0      0       0       0        0
sports_10.d2    1      1          0      0       0       0        0

FILE

Displays the name of the file for the statistics displayed. The file types can include: database files (.db extensions), Before-image files (.bi extensions), After-image files (.ai extensions), and application data extents (.dn extensions).

BUFFERED

Displays the number of buffered reads and writes to the database file for the associated row.

UNBUFFERED

Displays the number of unbuffered reads and writes to the database file for the associated row.

LOGICAL

Displays the number of client requests for database read and write operations for the associated row.

Notes

• The statistics are cumulative and are reset at database open or when PROUTIL ZEROSTATS is executed.
• IOSTATS is available only on multi-user databases.
• IOSTATS provides a useful alternative to PROMON when you are only interested in statistics on your database extents.
• You can use IOSTATS to determine if your files are opened in buffered or unbuffered mode.