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

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

Before you begin

Before you start this task, review the information in Configuration planning for a messaging engine to use a data store, and ensure that you have taken any appropriate action.

About this task

To create the database, schema and user ID for a messaging engine, complete the following steps.
[z/OS]Note: For detailed set up instructions for z/OS® see the IBM® Redbooks® publication Architecting High Availability Using WebSphere® V6 on z/OS.

Procedure

  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. For more information 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.