Use this task to enable WebSphere Application Server to
create the tables for the messaging engine data store.
Before you use this task, decide whether you want WebSphere Application Server to
create the tables.
Perform the following steps to enable
WebSphere Application Server to
create the
data store tables.
- Ensure that WebSphere Application Server has
sufficient authority to create tables and indexes. For more information
about the privileges that you require for your chosen database, refer to Database privileges.
- When you configure your messaging engine data store, ensure that Create
tables is selected. For more information, refer to Configuring a messaging engine to use a data source.
DB2 for z/OS restriction: The option for
WebSphere Application Server to
create the tables is not available with DB2 for z/OS. Do not select
Create
tables, otherwise an exception will be thrown when
WebSphere Application Server attempts
to create the tables. Refer to
Enabling your database administrator to create the data store tables if
you use DB2 for z/OS.