Enabling WebSphere Application Server to create the data store tables

Use this task to enable WebSphere® Application Server to create the tables for the messaging engine data store.

Before you begin

Before you use this task, decide whether you want WebSphere Application Server 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 Enabling your database administrator to create the data store tables if you use DB2 for z/OS.

Procedure

  1. Ensure that WebSphere Application Server has sufficient authority to create tables and indexes. For more information about the privileges that you require for your chosen database, refer to Database privileges.
  2. When you configure your messaging engine data store, ensure that Create tables is selected. For more information, refer to Configuring a messaging engine 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.



In this information ...


Related reference

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    

Terms of Use | Feedback

Last updated: Aug 29, 2010 10:43:27 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=v602web&product=was-nd-mp&topic=tjm0090
File name: tjm0090_.html