PROSTRCT STATISTICS qualifier
Displays statistics about storage information about the specified database.
Syntax
prostrct statistics db-name
|
Parameters
db-name
Specifies the database whose storage information you want.
PROSTRCT STATISTICS displays the following information:
![*](bullet.png)
Database name
![*](bullet.png)
Primary database block size and the before-image and after-image block sizes
![*](bullet.png)
Storage area and each extent within it
![*](bullet.png)
Total number of active blocks allocated for each data area
![*](bullet.png)
Total number of blocks for each data area
![*](bullet.png)
Total number of empty blocks in each data area
![*](bullet.png)
Total number of extent blocks for each data area
![*](bullet.png)
Total records per block for each data area
![*](bullet.png)
Total number of all blocks (active blocks, active free blocks, and empty blocks)
![*](bullet.png)
Date and time of the last full database backup
Notes
![*](bullet.png)
When PROSTRCT STATISTICS is run against a database that is in use, values may be changing as the display is output.
![*](bullet.png)
Do not run this utility against a database that has crashed. You must recover the database first.
![*](bullet.png)
A void database cannot be accessed by this command.