Previous Topic: More InformationNext Topic: Defining a Database Using SQL


Summary of Physical Database Limits

Data Limits

The following table summarizes the maximum values allowed for physical database definitions:

Item

Maximum allowed

Pages in a data buffer

16,777,214

Bytes in a database buffer page

32,764; multiple of 4

Journal buffer pages associated with a database

32,767

Bytes in a journal buffer page

32,768; multiple of 4

Files in a database

32,767

Files associated with an area

32,767

Areas associated with a file

32,767

Pages associated with an area

1,073,741,822

Bytes in a database page

32,764; multiple of 4

Blocks in a disk journal file

999,999

Bytes in an archive journal block

32,768