Data store performance

This topic tells you about the factors that affect the performance of a data store.

The workload that the messaging engine imposes on the relational database management system (RDBMS) is somewhat different from usual database workloads, because the messaging engine performs mainly SQL INSERT and DELETE operations. Take this workload into consideration when using the tuning guidelines supplied by your RDBMS provider. The following information might also assist your database administrator.

Each messaging engine can request a large number of concurrent connections to the database. By design, a messaging engine uses many threads to perform database updates concurrently. Consider configuring the connection pool for the JDBC data source used by the data store with sufficient connections to cope with peak workloads, for example, 50 connections. Your database administrator might need to change the database configuration to support this number of concurrent connections from the application server.

The performance of the data store influences messaging throughput to a significant extent. Throughput is usually limited by the write latency of the database log. Consider placing the database log on a fast, dedicated device that is configured for optimal write performance. Ideally, use a storage controller with a battery-backed memory cache so that the effects of disk rotation speed and seek latencies are not evident. For all except entry-level systems, use a RAID controller.

DB2 tip:

To get the best performance from messages in the 3KB to 20KB range, you should consider putting the SIBnnn tables into a tablespace with 32KB pages and adjusting the column width of the VARCHAR column to 32032 bytes.




Related concepts
Learning about data stores
Related tasks
Tuning the JDBC data source of a messaging engine
Problem solving for messaging engine data stores
Concept topic    

Terms of Use | Feedback

Last updated: Aug 29, 2010 8:25:23 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=vela&product=was-nd-zos&topic=cjm0470
File name: cjm0470_.html