Network Deployment (Distributed operating systems), v8.0 > Administer applications and their environment > Administer 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 WAS does it automatically, or that the database administrator does it manually. Before you begin this task, decide whether you want WAS to create the tables automatically, or whether you want your 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 data store tables manually if you use DB2 for z/OS.
Procedure
- If you want WAS to create the tables...
- Ensure that WAS has sufficient authority to create tables and indexes. For more information about the privileges required for your chosen database, see Database privileges.
- When you configure your messaging engine data store, ensure that the Create tables option is selected so that the messaging engine creates the tables in its chosen schema. 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 your database administrator to create the database tables manually, use the sibDDLGenerator command to generate the DDL statements that 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 data store tables manually.
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 data store tables manually
Related
Data store tables
Database privileges