Release 10.1A: OpenEdge Data Management:
Database Administration

> ## Number and size of storage areas

> An OpenEdge database supports a maximum of 1,000 storage areas, including 994 application data storage areas. Storage areas are identified by their names. Table 2–1 describes the area types.

> Table 2–1: Storage area types
> Reserved area name | Contents | File extension
> --- | --- | ---
> Control | Physical Database Structure | .`db`
> Primary Recovery | Recovery Log Data | .`b` `n`
> Transaction Log | Two-phase Commit Transaction Log | .`t` `n`
> After Image | After-image Log Data | .`a` `n`
> Schema | Schema Data | .`d` `n`
> – | Application Data | .`d` `n`

> Application data areas allow you to specify the maximum number of records per block for each area. With schema data storage areas, you cannot change the number of records per block. It will always remain 32 for 1K, 2K, and 4K database block sizes and 64 for an 8K database block size. The records per block are only tunable for data areas.

> Table 2–2 describes the maximum application data storage area size determined by database block size and records per block. These maximums assume large file support. If you do not have large file support enabled for your database, the maximum data storage area size is limited to 0.5TB.

> Table 2–2: Maximum application data storage area size
> Database block size | Records per block | Maximum area size
> --- | --- | ---
> 8192 bytes (8K) | 1 | 16TB
> 8192 bytes (8K) | 2 | 8TB
> 8192 bytes (8K) | 4 | 4TB
> 8192 bytes (8K) | 8 | 2TB
> 8192 bytes (8K) | 16 | 1TB
> 8192 bytes (8K) | 32 | 512GB
> 8192 bytes (8K) | 64 (default) | 256GB
> 8192 bytes (8K) | 128 | 128GB
> 8192 bytes (8K) | 256 | 64GB
> 4096 bytes (4K) | 1 | 8TB
> 4096 bytes (4K) | 2 | 4TB
> 4096 bytes (4K) | 4 | 2TB
> 4096 bytes (4K) | 8 | 1TB
> 4096 bytes (4K) | 16 | 512GB
> 4096 bytes (4K) | 32 (default) | 256GB
> 4096 bytes (4K) | 64 | 128GB
> 4096 bytes (4K) | 128 | 64GB
> 4096 bytes (4K) | 256 | 32GB
> 2048 bytes (2K) | 1 | 4TB
> 2048 bytes (2K) | 2 | 2TB
> 2048 bytes (2K) | 4 | 1TB
> 2048 bytes (2K) | 8 | 512GB
> 2048 bytes (2K) | 16 | 256GB
> 2048 bytes (2K) | 32 (default) | 128GB
> 2048 bytes (2K) | 64 | 64GB
> 2048 bytes (2K) | 128 | 32GB
> 2048 bytes (2K) | 256 | 16GB
> 1024 bytes (1K) | 1 | 2TB
> 1024 bytes (1K) | 2 | 1TB
> 1024 bytes (1K) | 4 | 512GB
> 1024 bytes (1K) | 8 | 256GB
> 1024 bytes (1K) | 16 | 128GB
> 1024 bytes (1K) | 32 (default) | 64GB
> 1024 bytes (1K) | 64 | 32GB
> 1024 bytes (1K) | 128 | 16GB
> 1024 bytes (1K) | 256 | 8GB

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095