Create data store tables
When creating the data store tables, we have two options. We can either choose that WebSphere Application Server does it automatically, or that the database administrator does it manually.
DB2 for z/OS restriction: The option for WAS to create the tables is not available with DB2 for z/OS. Rather, refer to Generate the DDL statements needed to create or alter data store 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.
Tasks
- To have WAS create the tables:
- Ensure that WAS has sufficient authority to create tables and indexes.
- When we configure our messaging engine data store, ensure that the Create tables option is selected so that the messaging engine creates the tables in its chosen schema. See Configure 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 WAS attempts to create the tables.
- To have the database administrator create database tables manually, use the sibDDLGenerator command to generate the DDL statements used to create the tables for the messaging engine data store.
Subtopics
Configure a JDBC data source for a messaging engine Configure a messaging engine data store to use a data source Database privileges Data store tables