Network Deployment (Distributed operating systems), v8.0 > Administer applications and their environment > Administer Service integration > Administer message stores > Administer data stores > Configure a messaging engine to use a data store > Create the database, schema and user ID for a messaging engine


Create the database for a data store

When you are creating a database to use as the data store for your messaging engine, choose a relational database management system (RDBMS) and create the database in accordance with your 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 you create a messaging engine. Make a note of the database parameters that you need for configuring the data source. See Configure a JDBC data source for a messaging engine.


Procedure

Refer to the documentation for your 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:

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. If you are using 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.
Create users and schemas in the database

+

Search Tips   |   Advanced Search