This section explains the procedure for tuning the number of server activation processes, which is part of the system activity statistical information provided by the statistics analysis utility. The purpose is to enable the system to activate server processes in an optimal manner by analyzing the number of active processes that were actually executing services and determining whether or not there were any service requests beyond the maximum number of active processes.

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

• In the front-end server or single-end server, it is the status in which a HiRDB client is allocated to a process by issuing the CONNECT statement. 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

21.6.1 Tuning the maximum number of active processes

21.6.2 Tuning the number of resident processes

21.6.3 Tuning the number of processes in asynchronous READ processing