Use this task to enable WebSphere Application Server to
create the tables for the messaging engine data store.
Before you begin
Before you use this task, decide whether you want WebSphere Application Server to
create the tables.
Why and when to perform this task
Perform the following steps to enable
WebSphere Application Server to
create the
data store tables.
Steps for this task
- 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 Modify data store configurations.
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.