Progress
Database Administration
Guide and Reference


Applicable Operating System Limits

Progress uses file handles (a UNIX term, roughly equivalent to the number of open files) when reading and writing to the Progress database and related files. Most operating systems limit the number of file handles a user process can allocate at one time. Most versions of UNIX guarantee at least 20. Therefore, before you can effectively design a database, you must know your operating system limits and how Progress will use the file handles that are available to it.

Use the following formula to determine the number of file handles Progress uses:

H = Static Handles + (# of .dn files) + (# of .bn files) + (# of .an files) 

H

The number of file handles Progress uses.

Static Handles

The number of handles allocated for any Progress database. The number of static file handles that the process requires depends on whether you are running a Progress client process or a Progress server process:

# of .dn files

The number of DB files defined for the database.

# of .bn files

The number of BI files defined for the database.

# of .an files

The number of AI files defined for the multi-volume database.

When calculating the number of file handles, consider the following exceptions:


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