Displays statistics about storage information about the specified database.

Syntax

prostrct statistics db-name [ -RO ]

Parameters

db-name

Specifies the database whose storage information you want.

-RO

Runs the utility in read-only mode. Use read-only mode to connect to databases on read-only media or to diagnose and repair issues on a stopped database before starting it. Read-only mode allows any number of connections at once, up to the maximum number of connections. This reduces bottlenecks and expedites disaster recovery on large databases.

Note: Use -RO with caution because it is designed to work only with a read-only connection. Unexpected errors may result if you specify -RO when using a single-user or multi-user connection.

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

• You can use this utility with an online database or with a stopped database that has a read-only connection. See Read-only connections.
• 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 Maintain Database Structure for more information about the STATISTICS qualifier with the PROSTRCT utility.