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
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 .d
n
files
The number of DB files defined for the database.
# of .b
n
files
The number of BI files defined for the database.
# of .a
n
files
The number of AI files defined for the multi-volume database.
When calculating the number of file handles, consider the following exceptions:
- If you are running a server in a UNIX environment that uses sockets for interprocess communication, add one file handle for each user.
- Application programs use additional file handles when reading and writing text files and when compiling programs. The formula does not account for these additional resource requests.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |