WebSphere WebSphere Application Server Express, Version 6.0.x Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

Creating the database

Use this task to create the database for your messaging engine.

Before you begin

Choose which relational database management system (RDBMS) you want to use for the data store. Unless you are using the embedded Cloudscape provider, create the database before you create a messaging engine.

Steps for this task

Refer to the documentation for your chosen RDBMS for information about how to create a database.
Cloudscape tip: Unless the database exists already, the messaging engine creates the Cloudscape database when the messaging engine makes its initial connection.
Sybase tips:
  • Ensure that you create the database server with a page size of at least 4k.
  • Ensure that you set the lock scheme property on your server to the value datarows. This avoids the possibility of a deadlock on the data store tables.
  • Ensure that you set the enable housekeeper GC property on your server to the value 5. This improves the ability of the server to reclaim redundant space within your database when it is under heavy load.
  • Ensure that you select the allow nulls by default option for your database instance. This is required for the correct operation of the messaging engine.
  • Ensure that you select the trunc log on chkpt option for your database instance. This prevents the database transaction log from filling up over time.

Task topic

Terms of Use | Feedback

Last updated: 2 Aug 2005
http://publib.boulder.ibm.com/infocenter/ws60help/index.jsp?topic=/com.ibm.websphere.pmc.express.doc\tasks\tjm0060_.html

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