DBMS Server Configuration
The Ingres client-server architecture allows multiple users access to databases through connections to one or more DBMS Server processes. The DBMS Server (iidbms) is a multi-threaded daemon process that performs asynchronous disk input and output. The number of users connected to a server is limited by hardware or the operating system.
Since it is unlikely that the default DBMS server configuration suits all users' requirements, the DBMS Server is usually configured to improve performance in a particular configuration. For a selected DBMS server definition, its buffer caches can be configured as well as other parameters and derived parameters.
DBMS servers can be configured to fit specific needs. For example, you can:
• Designate one server to access a particular database, denying other servers access to that database.
• Configure a server as a "fast commit" server to achieve higher levels of performance.
• Specify that two or more servers share a common memory buffer cache.
• Specify private buffer cache with distributed multi-cache protocol.
Note: Ingres preallocates most of the resources it requires. It may use hundreds of gigabytes of virtual memory and allocate millions of handles; the use of these resources depends on the number and size of the page caches enabled.
Last modified date: 11/28/2023