Create the database, schema and user ID for a messaging engine

Before the data store for a messaging engine can be set up, first create the database, the schema and the database user ID that the messaging engine needs to access the data store tables.

Before you start this task, review the information in Plan the configuration of a messaging engine to use a data store, and ensure that we have taken any appropriate action. To create the database, schema and user ID for a messaging engine...

1. Create the database for the data store.

2. 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.

   See about the privileges that are required for the selected database, see Database privileges.

3. If required, create the data store tables by using the data definition language (DDL) statements generated by using the sibDDLGenerator command.

---

Last updated Dec 15, 2010 8:14:22 PM CST