After you have created a database, you create the schema
in which all tables in the data store are held. Depending on which database
you are using, you create one or more database user IDs to enable
the messaging engine to access the data store tables.
Before you begin
Before you begin this task, you must first create the database for
your messaging engine.
About this task
To
connect to
WebSphere® Application Server, you must
create at least one messaging engine user ID. The number of user IDs you need
depends on the database you use:
- If you are using Derby, DB2®, or Oracle, the messaging engine can be configured
to create any additional schemas that might be required for other data stores.
That is, if you only create one user, it can have one to many relationships
with the schemas in the database. See Configuring a messaging engine data store to use a data source for
details.
- For all other types of databases, the schemas must be created before
starting the messaging engines that depend on them.
If a database user ID can be configured to use multiple schemas,
then only that user ID is needed for all messaging engines. Otherwise the
user ID is restricted to using tables in its own schema. In this case there
can be only one user ID per schema.
Procedure
-
Create the users and schema in accordance with the documentation
for your chosen relational database management system (RDBMS).
With DB2 databases,
you create users and schema in separate steps. With the other databases, there
is a one-to-one relationship between a schema and a user.
-
Ensure that the messaging engine user ID has the privileges required
to enable the messaging engine to access the data store tables and, if required,
create the data store tables automatically.
See Database privileges.