Increasing the number of item tables for a messaging engine when tables are not automatically created

If a concurrency bottleneck had occurred on the item tables, increasing the number of them will in turn increase the throughput of the messaging engine.

Before you begin

Before performing this task you must ensure that the messaging engine is using a data store, and its Create tables automatically option is set to False. The purpose of this task is to relieve concurrency bottleneck, which is documented in Increasing the number of data store tables to relieve concurrency bottleneck. For more information on the creation of tables consult Creating the tables.

Procedure

  1. Relevant performance monitoring tools show that the throughput of a messaging engine is inefficient.
  2. Use your database performance monitoring tools to examine lock statistics for the item tables for evidence of a bottleneck. Consult database documentation on how to interpret the locking statistics.
  3. Create tables and increase data store attributes. You can only increase the number of permanent tables or temporary tables, not decrease them.
  4. Stop and restart the WebSphere® Application Server so that configuration changes take effect. The extra tables are used when the messaging engine restarts.
  5. Observe the effect on throughput and lock statistics by checking performance monitoring tools. Consider whether any improvement is sufficient and modifying the data store attributes further would be beneficial



In this information ...


Related tasks

IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic Task topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Aug 30, 2013 8:21:57 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=pix&product=was-express-iseries&topic=tjm0025_
File name: tjm0025_.html