WebSphere WebSphere Application Server Network Deployment, Version 6.1.x Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows, z/OS

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.
Related tasks
Configuring a messaging engine to use a data source
Enabling your database administrator to create the data store tables
Related reference
Database privileges

Task topic

Terms of use | Feedback


Timestamp icon Last updated: 26 February 2009
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.pmc.nd.multiplatform.doc/tasks/tjm0090_.html

Copyright IBM Corporation 2004, 2009. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)