WAS v8.5 > Tune performance > Tune Service integration > Tune messaging engine data stores

Tune the JDBC data source of a messaging engine

The messaging engine needs to have the correct configuration for JDBC data source to achieve messaging performance on a service integration bus.

Consider whether configure the connection pool for the JDBC data source to achieve your requirements for messaging performance.

The messaging engine uses the connection pool to obtain its connections to the database. With a heavy workload, a messaging engine might require a large number of concurrent connections to avoid delays waiting for connections to become available in the pool. For example, a very heavily loaded messaging engine might need 50 or more connections. To configure the connection pool to meet your performance requirements:

  1. Ensure the configuration of your relational database management system (RDBMS) permits the number of connections that you require. Refer to the documentation for the RDBMS for more information.

  2. Use the dmgr console to set the connection pool parameters for the data source. Navigate to Resources -> JDBC -> Data sources -> data_source_name -> [Additional Properties] Connection pool properties.

    1. Set Maximum connections to the number of connections you require, for example, at least 50. The default number of connections is 10.

      If your messaging engine times out when requesting a database connection, check the error log. If the error log contains error message CWSIS1522E, increase the number of connections and ensure the configuration of your RDBMS permits that number of connections.

    2. Set Purge policy to EntirePool. This policy enables the connection pool to release all connections when the messaging engine stops.


Related concepts:

Data store performance


Related


Set tuning properties of a messaging engine
Controlling the memory buffers used by a messaging engine
Set tuning properties by editing the sib.properties file


+

Search Tips   |   Advanced Search