This section describes the estimation of resources used by the DBMS.
For details about the required virtual memory, see 6.3 Estimating virtual memory usage. For details about the disk occupancy see release notes of Application Server or Developer.
The following table describes the estimation of the resources used by the DBMS:
Table 6-6 Estimation of resources used by DBMS
DBMS | Used resources | Requirement |
---|
HiRDB | Maximum number of concurrent connections (pd_max_users) | ![[Figure]](figure/zu062000.gif) |
Oracle | Maximum number of concurrent connections (PROCESSES) | ![[Figure]](figure/zu062100.gif) |
- #1
- n is the total number of resource adapters deployed on the batch server in the system.
- #2
- Specify the value of the MaxPoolSize parameter in the Connector property file.
- #3
- Multiply by the value 2 if the following conditions are applicable:
- Use XATransaction in the transaction support level.
- Use the connection# within the transaction managed by Application Server to access the database.
- Before the transaction of step 2 concludes, use the connection# outside the transaction to access the database.
- #: This connection is the one that is acquired from the DB Connector in step1 and is the same connection.
- #4
- Add 1 only for the resource adapters with XATransaction specified in the transaction support level.
- #5
- +
indicates connections that might temporarily exceed the maximum value for the connection pools. The details are as follows: - When the functionality for detecting a connection failure is used
When implementing the functionality to detect a connection failure, the unused connections removed from a connection pool are not counted as the connections within the connection pool. Therefore, the total number of connections in a connection pool and the unused connections removed from the connection pool might temporarily exceed the maximum number of connections in the connection pool.
- When the cjclearpool command is used
In the normal mode, the used connections that are removed from a connection pool are not included in the connection count. Therefore, the total number of connections in the connection pool and the used connections removed from the connection pool might exceed the maximum value for the connection pool.