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.