After
setting up a data store and configuring its data source, you can configure
a messaging engine to use the data source.
About this task
A messaging engine uses an instance of a JDBC data
source to interact with the database that contains the data store
for that messaging engine.
Use the WebSphere® Application Server
administrative console to set the data store configuration parameters.
Perform
the following steps to configure the messaging engine to use a data
source using the administrative console:
Procedure
- In the navigation pane, click .
- In the content pane, click the name of the bus to which
your messaging engine belongs.
- Under Topology, click Messaging
engines. A list of messaging engines
is displayed.
- Click the messaging engine name.
- On the Configuration pane, find
the Message store type option, which is Data
store.
- Click on the Configure button.
- On a new page, specify the following properties:
- Data source name
- Type the JNDI name of the data source that provides access to
database that holds the data store.
- Schema name
- Type the name of the database schema that contains the tables
used by the data store.
General tip: The
schema name is usually the same as the user ID that is declared in
the authentication alias. With some databases, for example DB2®, you can provide an alternative
schema name. For more information about the relationship between users
and schema, refer to the documentation for your chosen RDBMS.
Informix tip: When you
configure your messaging engine to use an Informix® database, you must specify the
schema name in lower case.
When
starting, a messaging engine that uses a data store checks to see
if its data store exists. If the user has selected the Create tables option
in the configuration, whose tick-box is ticked by default, the messaging
engine creates the tables in its chosen schema.
The
Schema name field
is optional, and:
- The default schema name is IBMWSSIB.
- If you delete the text so that field is blank, the messaging engine
takes the user id defined in the authentication alias to be the schema
name.
- If you define a schema name explicitly, that schema name is used
by the messaging engine.
- Authentication alias
- Select the authentication alias that enables access to the data
source.
- Create tables
- Select the check box if you want WebSphere Application Server to create the database
tables automatically. For more information, refer to Creating the tables.
Note: The user ID that the
data store uses to connect to the data source must have sufficient
authority to create the database tables and indexes.
- Number of permanent tables
- Permanent table contains persistent objects for the data store.
Note: You
can only increase the number of permanent tables or temporary tables,
not decrease them.
See related links for more information.
- Number of temporary tables
- Temporary tables nonpersistent objects that have been saved to
the data store to reduce the messaging engine memory requirement.
Note: You
can only increase the number of permanent tables or temporary tables,
not decrease them.
See related links for more information.