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.
SIBXACTS table restriction: Service
integration bus does not support padded values in the XID column of
the SIBXACTS table. Hence, any database parameter setting that might
add padded values to the column must not be applied to the database.
For
example, changing the value of the RETVLCFK DB2
parameter from NO to YES might introduce
padded values.
For more information about the RETVLCFK parameter,
see VARCHAR FROM INDEX field (RETVLCFK subsystem
parameter) in the DB2 information center.
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 or alter data store tables.