8.5.3 Tuning parameters for optimizing the method of accessing the database

(1) Connection pooling

This subsection explains how to set up tuning parameters for connection pooling.

Specify the items listed in the following table using the server management command (cjsetresprop / cjsetrarprop) for each resource adapter and define the parameters in the Connector property file.

Table 8‒23: Tuning parameters of connection pooling

Setup item	Location of setup (parameter name) #1
Minimum number of connections for pooling in the connection pool	MinPoolSize specified in <property> tag
Maximum number of connections for pooling in the connection pool	MaxPoolSize specified in <property> tag
Select the method for checking connection failures within the pool	ValidationType specified in <property> tag
Time interval for regularly checking for any connection failure within the pool	ValidationInterval specified in <property> tag
Specify whether the requests for connections are to be queued when all connections are in use	RequestQueueEnable specified in <property> tag
Waiting time when a connection request is managed in a queue when all connections are being used	RequestQueueTimeout specified in <property> tag
Retry frequency in the case of a connection failure#2	RetryCount specified in <property> tag
Retry interval in the case of a connection failure#2	RetryInterval specified in <property> tag
Time until it is decided to automatically delete the connections, from the time connection was used last	ConnectionTimeout specified in <property> tag
Time interval before automatic deletion of connection is executed (connection sweeper)	SweeperInterval specified in <property> tag
Specify whether connection warm-up is to be used	Warmup specified in <property> tag
Specify whether to set a timeout for detecting the connection failure#3	NetworkFailureTimeout specified in <property> tag
Specify whether to set a timeout for the deletion process of connection adjustment functionality#3
Time interval for executing the connection adjustment functionality	ConnectionPoolAdjustmentInterval specified in <property> tag

Tip

We recommend the following settings to use the connection pooling functionality in HiRDB or XDM/RD E2:

• To use the connection pooling functionality in HiRDB

  Set the HiRDB client environment variable such that the HiRDB server does not sever the connection. For details, see the HiRDB UAP Development Guide.

• To use the connection pooling functionality in XDM/RD E2

  Specify 0 in the SVINTERVAL parameter of the control statement for invoking the control space or the control statement for invoking the server space of the DB connection server. For details on this parameter, see the manual VOS3 Database Connection Server.

If the above settings are not specified, the pooled connections might be disconnected from the database due to a timeout.

• If the error detection functionality is used

  The connections disconnected from the database due to a timeout are destroyed using the error detection functionality. A connection can be acquired normally.

• If the error detection functionality is not used

  The connections disconnected from the database due to a timeout are acquired.

To Page Top

(2) Statement pooling

This subsection explains how to set up the tuning parameters of statement pooling.

Specify the items listed in the following table using the server management command (cjsetresprop / cjsetrarprop), and define the parameters in the Connector property file.

Table 8‒24: Tuning parameters of a statement pooling

Setup item	Parameter name#
Number of PreparedStatement to be pooled for each physical connection	PreparedStatementPoolSize specified in <config-property> tag
Number of CallableStatement to be pooled for each physical connection	CallableStatementPoolSize specified in <config-property> tag

To Page Top