Planning the configuration of a messaging engine to use a data
store
There
are a number of choices that you need to consider before you configure
a messaging engine to use a data store.
Procedure
Choose the relational database management system (RDBMS)
for the data store. You might want to choose the RDBMS
that you use for other applications, particularly if you are already
familiar with the tools you use for managing that RDBMS. You might
also want to consider the following criteria:
Performance
Scalability
Availability, especially if you are running messaging engines
in a high availability environment
When a new messaging engine which uses a
data store is created on a single server, it is configured to use
a Cloudscape
Version 10.1.x (Derby) data source by default. This enables the
messaging engine to run without needing any additional configuration.
The default embedded Derby data source is sufficient for many purposes.
Other relational database management systems offer more comprehensive
tooling and improved performance, particularly scalability on larger
machines with more than two processors.
Supported configurations: WebSphere Application
Server supports direct customer use of the Cloudscape database in test environments only. The product does not support direct customer
use of Cloudscape database in production environments.sptcfg
Choose your database topology. In some cases,
running the data store on a remote node can improve performance. In
other cases, a local database provides performance equivalent to a
remote database. You might want to conduct your own performance analysis,
because the performance characteristics can be very sensitive to the
hardware specification.
Consider whether you want WebSphere® Application Server to create the data
store tables automatically or whether you want your database administrator
to create the tables beforehand. For more information,
refer to Creating the tables.
Message data is stored in a database table column of datatype
BLOB. Before you create a datastore, you must consider the size of
your expected workload to ensure that your database administrator
creates a sufficiently large enough BLOB space to hold your message
data.
Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.
This feature requires Internet access.
Most of the following links will take you to information that is not part of the formal product documentation and is provided "as is." Some of these links go to non-IBM Web sites and are provided for your convenience only and do not in any manner serve as an endorsement by IBM of those Web sites, the material thereon, or the owner thereof.
Last updated: Aug 31, 2013 2:56:59 AM CDT http://www14.software.ibm.com/webapp/wsbroker/redirect?version=pix&product=was-nd-dist&topic=tjm0035_ File name: tjm0035_.html