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 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.
(ZOS) Note: For detailed set up instructions for z/OS see the IBM Redbooks publication Architecting High Availability Using WebSphere V6 on z/OS.
Tasks
- 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.
- 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
- Create the database for a data store
- Create users and schemas in the database
Related:
Messaging engines Bus members Add a messaging engine to a cluster Generate the DDL statements needed to create or alter data store tables Add a cluster as a member of a bus Messaging engine troubleshooting tips