Kbase P7434: How to estimate space allocated for a table within a database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
How to estimate space allocated for a table within a database
FIX:
Progress provides the proutil dbanalys tool that allows the user to determine the size of the records per each table as well as how many blocks each of the index structure is being used. The syntax of the command is:
proutil <db-name> -C dbanalys
This information is helpful for the database administrator to have an idea of how much space will be necessary in case of a dump/load process, index rebuild or even moving a table to another area.
For record information, get the number of records and the total size of the records for this table as well as some statistics about them such as minimum, maximum and mean size. This is a reduced version of output for the Customer table of sports database:
Table Records Size Min Max Mean
PUB.Customer 1117 147.1K 98 225 134
For indexes, the utility give the size of each index structure and the number of blocks used to store the indexes keys. This is a reduced version of the output for the Indexes of Customer table:
Table Index Fields Levels Blocks
PUB.Customer
Comments 13 1 1 1
CountryPost 14 2 2 4
CustNum 12 1 2 4
Name 15 1 2 7
SalesRep 16 1 1 1