Consultor Eletrônico

Status: Verified

GOAL:

How large can a database be in Progess Version 9.1x, OpenEdge 10.0x and 10.1x?

GOAL:

What is the maximum extent size for a database with Large Files enabled?

GOAL:

How to calculate the maximum database size

GOAL:

How large can a database grow

GOAL:

What is the maximum size of a Progress database

FACT(s) (Environment):

Progress 9.1X
All Supported Operating Systems
OpenEdge 10.0x
OpenEdge 10.1x

FIX:

For Progress Version 9.1x, OpenEdge 10.0x and 10.1A, the maximum size of a database is determined by the following formulas:
max-database-size = max-storage-area-size * max-number-of-storage-area

where
max-storage-area-size = max-number-db-blocks-per-area * db-block-size
and
max-number-db-blocks-per-area = max-number-records-per-area / recs-per-block


The maximum number of areas a database can support is 1000. The first six areas are reserved, leaving 994 available data areasleaving for the application.
The number of extents per area is also 1000.

For example, using one (1) record per block and an 8K (8192) byte block size allows a maximum storage area size equal to 16TB (terabytes), and a maximum size of a database to be approximately 16PB (petabytes) as shown in the following calculations:

max-number-db-blocks-per-area = max-number-records-per-area / recs-per-block
= 2,000,000,000 / 1
= 2,000,000,000
max-storage-area-size = max-number-db-blocks-per-area * db-block-size
= 2,000,000,000 * 8192
= 16384,000,000,000
max-database-size = max-storage-area-size * max-number-of-storage-area
= 16384,000,000,000 * 1000
= 16384,000,000,000,000
= 16PB
In the books referenced below in chapter 3 on database limits, table 3.2 " Maximum Application Data Storage Area Size " lists the maximum size for an area based on database blocksize and the number of records per block.
This table was based on Large File Support being enabled. On OS platforms, where Large Files are not supported by Progress, the