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 store

Create data store tables

When you create the data store tables, we have two options. We can either choose that WebSphere Application Server does it automatically, or the database administrator does it manually.

Before beginning this task, decide whether you want WAS to create the tables automatically, or whether you want the database administrator to create the tables.

DB2 for z/OS restriction: The option for WAS to create the tables is not available with DB2 for z/OS . Refer to Generate the DDL statements needed to create or alter data store tables if we use DB2 for z/OS.

• If you want WAS to create the tables...
  1. Ensure that WAS has sufficient authority to create tables and indexes. For more information about the privileges required for the chosen database, see Database privileges.

  2. When you configure your messaging engine data store, ensure the Create tables option is selected so the messaging engine creates the tables in its chosen schema. For more information, see Configure a messaging engine data store to use a data source.

     DB2 for z/OS restriction: Do not select Create tables, otherwise an exception will be thrown when WAS attempts to create the tables.

• If you want the database administrator to create the database tables manually, use the sibDDLGenerator command to generate the DDL statements the database administrator needs to create the tables for the messaging engine data store. For further information, see Generate the DDL statements needed to create or alter data store tables.

Subtopics

• Generate the DDL statements needed to create or alter data store tables
  To enable the database administrator to create or alter the data store tables manually, you must generate data definition language (DDL) statements.

Related

Configure a JDBC data source for a messaging engine
Configure a messaging engine data store to use a data source
Generate the DDL statements needed to create or alter data store tables

Reference:

Database privileges
Data store tables

+

Search Tips   |   Advanced Search