Before the data store for a messaging engine can be set
up, you must first create the database, the schema and the database
user ID that the messaging engine needs to access the data store tables.
About this task
To create the database, schema and user ID for a messaging
engine, complete the following steps.
Procedure
- Create the database for
the data store.
- Create users and
schemas in the database. Ensure that the user ID
has sufficient privilege to allow the messaging engine to access the
data store tables. For more information about the privileges that
are required for the selected database, see Database privileges.
- If required, create the data store tables by using the
data definition language (DDL) statements generated by using the sibDDLGenerator
command.