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:

• 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

Notes

• When PROSTRCT STATISTICS is run against a database that is in use, values may be changing as the display is output.
• 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.