Create data store tables
When we create 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.
Before beginning this task, decide whether we want WebSphere Application Server to create the tables automatically, or whether we want the 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 Generating the DDL statements needed to create or alter data store tables 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 VARCHAR FROM INDEX field (RETVLCFK subsystem parameter) in the DB2 information center.
- If we want WebSphere Application Server to create the tables...
- Ensure that WebSphere Application Server has sufficient authority to create tables and indexes. For more information about the privileges required for the chosen database, see Database privileges.
- When you configure the 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 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 WebSphere Application Server attempts to create the tables.
- If we want the 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.
Subtopics
- Generating the DDL statements needed to create or alter data store tables
To enable the database administrator to create or alter the data store tables manually, generate DDL statements.
Related tasks
Configure a JDBC data source for a messaging engine Configure a messaging engine data store to use a data source Generating the DDL statements needed to create or alter data store tables
Database privileges Data store tables