Kbase P106246: How to calculate the maximum storage area size ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/05/2009 |
|
Status: Verified
GOAL:
How to calculate the maximum storage area size ?
GOAL:
What is the Progress database maximum storage area size limit ?
GOAL:
How big can a storage area be ?
GOAL:
How to calculate the Maximum Number of Database Blocks Per Storage Area ?
GOAL:
What is the Maximum data storage area size with a database 1k blocksize?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.0x
OpenEdge 10.1A
FIX:
The maximum storage area size is determined by three values:
The maximum number of records per storage area, which is equal to 2,147,483,648
Number of records per block of the area as defined in the structure file dbname.st
Database block size
To calculate the maximum storage area, first, it is necessary to calculate the Maximum number of database blocks per storage area using:
Maximum number of database blocks per storage area = Maximum number of records per storage area / number of records per block
Then use the result to calculate the Maximum storage area size:
Maximum storage area size = Maximum number of database blocks per storage area * Database block size
For example: A database that uses 32 records per block and a 4K (4096 bytes) database block size.
Maximum number of database blocks per storage area = 2,147,483,648 / 32 = 67,108,864
Maximum storage area size = 67,108,864 * 4096 = 274,877,906,944 bytes = 256GB.