How to set up the tuning parameters used to optimize the method of accessing a database is explained in this section.
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-24 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 |
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-25 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 |