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 starting, 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...
(zos) Note: For detailed set up instructions for z/OS see the IBM Redbooks publication Architecting High Availability Using WebSphere V6 on z/OS.
- 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 required for the selected database, see Database privileges.
- If required, create the data store tables using the 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 the selected RDBMS.
- Create users and schemas in the database
After we have created a database, we create the schema in which all tables in the data store are held. Depending on which database you are using, we 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 tasks
Add a messaging engine to a cluster Generating the DDL statements needed to create or alter data store tables Add a cluster as a member of a bus
Related information:
Messaging engine troubleshooting tips