Progress
Database Administration
Guide and Reference
Progress Structure Statistics Utility
Use the Progress Structure Statistics Utility (PROSTRCT STATISTICS) to monitor database growth and the availability of free blocks for storing additional data. For example:
You specify the database whose storage information you want and the PROSTRCT STATISTICS utility displays information about:
- The database name
- The primary database block size and the before-image and after-image block sizes
- The storage area and each extent within it
- The total number of active blocks allocated for each data area
- The total number of empty blocks in each data area
- The total number of extent blocks for each data area
- The total number of blocks for each data area
- The total records per block for each data area
- The total number of all blocks (active, data, free, empty, extent, and total blocks)
- The date and time of the last full database backup
For example, this command displays database storage information for the database
/usr/joe/service.db
:
If a full backup has not yet been performed against
service.db
, the message would read “NO FULL BACKUP HAS BEEN DONE.”
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |