Progress
Database Administration
Guide and Reference


PROUTIL IOSTATS Qualifier

Provides current statistics for active databases. The statistics include buffered, unbuffered, and logical I/O database operations. The statistics are cumulative from database startup.

SYNTAX

Operating System
Syntax
UNIX
Windows
proutil db-name -C iostats

db-name

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

EXAMPLE

The following is a sample display of PROUTIL IOSTATS output:

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 

DISPLAY FIELDS
FILE

Displays the name of the file where the statistics are 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


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095