Kbase P106648: How to determine the amount of disk space being used overall for data blocks verses index blocks for
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/07/2010 |
|
Status: Verified
GOAL:
How to determine how much disk space is being used for data blocks verses index blocks for an existing database?
GOAL:
How to proactively plan for amount of disk space necessary for a new database based off existing database information?
GOAL:
How to determine how much space in a database is being used by data and how much being used by indexes?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
Run dbanalys and redirect it to a file. Example: proutil dbname -C dbanalys > filename.out
Review the output file and check for the following lines at the bottom of the output file for grand totals.
XXXXX RM block(s) found in the database.
XXXXX index block(s) found in the database.
Take the total # of RM blocks in the database and multiply this by your database block size to identify the amount of disk space required for data in your database.
Take the total # of index blocks located in the database and multiply this by database block size to determine the amount of disk space being used for indexes.