In a clustered environment with multiple JVMs running IBM Sterling B2B Integrator, how is the total number of database connections related to the number of connection pools?
A.
The total number of connections is the same as the number of connection pools.
B.
Each connection pool has a separate database connection regardless of the number of JVMs.
C.
The total number of connections is independent of the number of connection pools.
D.
The total number of connections is the sum of connections across all connection pools.
Sterling B2B Integrator uses internal connection pooling so that connections to the database server are reused instead of created for each request. Every JVM that runs part of the product, such as the application server nodes, the adapter container nodes and the operations server, creates its own connection pools. A pool holds a number of connections up to its configured maximum size, and when all pools are in use the system may request additional connections up to the buffer size. In a cluster, the database therefore sees the combined demand of every pool in every JVM. The total number of connections is the sum of the connections in all those pools, and it grows as nodes or pools are added. This is the reason capacity planning must multiply pool sizes by the number of JVMs and compare the result with the maximum number of sessions the database allows. If the total exceeds that limit, new connection attempts fail. A pool is not equal to a single connection, and a pool does not use one connection regardless of the number of JVMs. The total is also clearly dependent on the pools, which is why option D is correct.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit