Progress
Database Administration
Guide and Reference
PROSTRCT STATISTICS Qualifier
Displays the following information:
- Database name
- Primary database block size and the before-image and after-image block sizes
- Storage area and each extent within it
- Total number of active blocks allocated for each data area
- Total number of blocks for each data area
- Total number of empty blocks in each data area
- Total number of extent blocks for each data area
- Total records per block for each data area
- Total number of all blocks (active blocks, active free blocks, and empty blocks)
- Date and time of the last full database backup
SYNTAX
db-name
Specifies the database whose storage information you want.
NOTES
- Do not use PROSTRCT STATISTICS when a database is in use.
- Do not run this utility against a database that has crashed. You must recover the database first.
- A void database cannot be accessed by this command.
- See "Maintaining Database Structure," for more information about the STATISTICS qualifier with the PROSTRCT utility.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |