Progress
Database Administration
Guide and Reference
PROMON Database Status Option
Displays database block usage statistics and general status information. Figure 19–10 shows an example of this option’s output.
Figure 19–10: Sample Output For PROMON Database Status Option
DISPLAY FIELDS
Because most of the Database Status option output is self-explanatory, this list describes only five items:
Database state
One of the following values, set in the database master block:
Database State Description 1 The database is open. 2 The database is closed, used on disk. 3 The database is being recovered.
Total number of database blocks
The actual database size in disk blocks.
Number of empty blocks
The number of empty blocks in the database. Empty blocks are created when the database outgrows its existing block allocation, and also by record and index deletion. Progress expands the database by multiple blocks at a time—usually 8 or 16—and most of these are empty at first. Typically, the number of empty blocks increases and decreases as the database grows.
Record blocks with free space
Free space is created when records are deleted and when the database grows into a new block, but does not use the entire block. Progress reuses empty space with new records when possible, but does not return empty space to the operating system. This space does not affect Progress performance. However, if you must reclaim this disk space for your system, you can dump and reload the database.
Time since last truncate bi
The time in seconds since the before-image (BI) file was truncated. When the BI file is truncated, all modified database blocks are written to disk.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |