Progress
Database Administration
Guide and Reference


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


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