Enabling WebSphere Application Server to create the data store tables

WebSphere® Application Server can create the tables for the messaging engine data store automatically.

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 Task topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Aug 30, 2013 10:47:11 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=pix&product=was-nd-iseries&topic=tjm0090
File name: tjm0090_.html