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.
DB2 for z/OS restriction: The option for
WebSphere Application Server to create the tables is not available with DB2® for z/OS®. Refer to
產生建立或變更資料儲存庫表格時所需的 DDL 陳述式 if you use DB2 for z/OS.
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 the DB2
documentation.
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 產生建立或變更資料儲存庫表格時所需的 DDL 陳述式.