Using the statistical information on system operation obtained by the statistics analysis utility, perform tuning of the number of server processes. The purpose of this tuning is to enable the system to start server processes in the optimal state by analyzing the number of server processes that were actually executing services, and determining whether there were service requests that exceeded the maximum number of active processes allowed.

The phrase during service execution in this section refers to the following status in a server:

• In a front-end server or single server, it is the status in which a HiRDB client issues the CONNECT statement and is allocated to a server process. This status remains until the DISCONNECT statement is issued.
• In a back-end server or dictionary server, it is during execution of a transaction. This status remains until the transaction is terminated.

Information to be collected

System activity statistical information is collected by the statistics analysis utility.

Organization of this section

23.6.1 Tuning the maximum number of active processes

23.6.2 Tuning the number of resident processes

23.6.3 Tuning the number of asynchronous READ processes