WebSphere WebSphere Application Server Version 6.1.x Feature Pack for Web Services Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows, z/OS

Tuning 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.

Before you begin
Consider whether you need to configure the connection pool for the JDBC data source to achieve your requirements for messaging performance.
About this task
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. Perform the following steps to configure the connection pool to meet your performance requirements:

Procedure

  1. Ensure that the configuration of your relational database management system (RDBMS) permits the number of connections that you require. Refer to the documentation for your RDBMS for more information.
  2. Use the WebSphere Application Server administrative console to set the connection pool parameters. Navigate to the General properties for your data source and click Additional properties > Connection pool properties
    1. Set the Maximum connections to the number of connections you require, for example, at least 50. The default number of connections is 10.
      Tip: 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 that the configuration of your RDBMS permits that number of connections.
    2. Set the Purge policy to EntirePool. This policy enables the connection pool to release all connections when the messaging engine stops.
      Important: You must set this value if the messaging engine can failover in a cluster.
Related concepts
Data store performance
Related tasks
Setting tuning properties of a messaging engine
Controlling the memory buffers used by a messaging engine
Setting tuning properties by editing the sib.properties file
Related reference
For z/OS platforms Workload classification for service integration work

Task topic

Terms of use | Feedback


Timestamp icon Last updated: 27 November 2008
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.pmc.wsfep.multiplatform.doc/tasks/tjm0230_.html

Copyright IBM Corporation 2004, 2008. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)