WAS v8.5 > Administer applications and their environment > Welcome to administering Service integration > Administer message stores > Administer data stores > Configure a messaging engine to use a data storeCreate 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 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...
- Create the database for the data store.
- Create users and schemas in the database. Ensure the user ID has sufficient privilege to allow the messaging engine to access the data store tables. For more information about the privileges required for the selected database, see Database privileges.
- If required, create the data store tables using the data definition language (DDL) statements generated using the sibDDLGenerator command.
Subtopics
- Configure a messaging engine data store to use a data source
After configuring a JDBC data source, we can configure a messaging engine data store to use the data source.- Create the database for a data store
When you are creating a database to use as the data store for the messaging engine, you must choose a relational database management system (RDBMS) and create the database in accordance with your selected RDBMS.- Create users and schemas in the database
After we 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.
Related concepts:
Messaging engines
Bus members
Related
Generate the DDL statements needed to create or alter data store tables
Related information:
Messaging engine troubleshooting tips