Number and Size Of Storage Areas
A Progress database supports a maximum of 1,000 storage areas, including 994 application data storage areas. Storage areas are identified by their names. Table 3–1 describes the area types in a Progress database.
Table 3–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]
|
None
|
Application Data
|
.d[n]
|
Application data and schema data storage areas allow you to specify the maximum number of records per block for each area. Table 3–2 describes the maximum application data storage area size determined by database block size and records per block.
Table 3–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
|