Network Deployment (Distributed operating systems), v8.0 > Administer applications and their environment > Administer Service integration > Administer message stores > Administer data stores > Configure a messaging engine to use a data store
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 Configuration planning for 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, 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.
Messaging engines
Bus members
Add a cluster as a member of a bus
Add a messaging engine to a cluster
Generate the DDL statements needed to create data store tables manually
Configure a data source for a messaging engine running in a cluster
Messaging engine troubleshooting tips