Create the database for a data store
When you are creating a database to use as the data store for the messaging engine, you must choose a relational database management system (RDBMS) and create the database in accordance with the selected RDBMS.
Choose which Relational Database Management System (RDBMS) to use for the data store. Unless you are using the embedded Apache Derby provider, create the database before creating a messaging engine. Make a note of the database parameters that we need for configuring the data source. For more information, see Configure a JDBC data source for a messaging engine.
Refer to the documentation for the chosen RDBMS for information about how to create a database.
The default database for a data store is an embedded Apache Derby database. If we have chosen to configure the bus member to use a data store with default settings, it can only be a server. Unless the data store database exists already, the messaging engine creates the database automatically when the messaging engine makes its initial connection.
Sybase tips:
- Ensure that we create the database server with a page size of at least 4 KB.
- Ensure set the lock scheme property on the server to the value datarows. This avoids the possibility of a deadlock on the data store tables.
- Ensure set the enable housekeeper GC property on the server to the value 5. This improves the ability of the server to reclaim redundant space within the database when it is under heavy load.
- Ensure selected the allow nulls by default option for the database instance. This is required for the correct operation of the messaging engine.
Informix tip: The one-to-one relationship between a messaging engine and a data store means that every messaging engine must have its own database tables. For the Informix RDBMS, configure a separate database instance for each messaging engine. Problems have been observed in this environment when the data stores for multiple messaging engines were configured to use separate schemas in the same database.
Related tasks
Create users and schemas in the database