When you create the data store tables, you have two options. You
can either choose that
WebSphere® Application Server does
it automatically, or that the database administrator does it manually.
Before you begin
Before you begin this task, decide whether you want
WebSphere Application Server to
create the tables automatically, or whether you want your database administrator
to create the tables.
Procedure
-
If you want
WebSphere Application Server to
create the tables, complete the following steps:
-
Ensure that
WebSphere Application Server 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.
For more
information, see Configuring 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
WebSphere Application Server 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 Generating the DDL statements needed to create data store tables manually.
What to do next