Creating data store tables

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 Generating the DDL statements needed to create data store tables manually if you use DB2 for z/OS.
SIBXACTS table restriction: [Updated in June 2013] 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.

[Updated in June 2013]
jun2013

Procedure




In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic Task topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Feb 5, 2014 9:49:51 PM CST
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=compass&product=was-nd-mp&topic=tjm0080
File name: tjm0080_.html