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
db-name
Specifies the active database where you are running database I/O statistics.
EXAMPLEThe following is a sample display of PROUTIL IOSTATS output:
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
- The statistics are cumulative and are reset at database open.
- 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.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |