Data store [Settings]

The persistent store for messages and other state managed by the messaging engine.

To view this page in the console, click the following path:

Service integration -> Buses -> bus_name -> [Topology] Messaging engines -> engine_name -> [Additional Properties] Message store.

Configuration tab

The Configuration tab shows configuration properties for this object. These property values are preserved even if the runtime environment is stopped then restarted. See the task descriptions for information about how to apply configuration changes to the runtime environment.

General Properties

UUID

The universal unique identifier assigned by the system to this data store for administrative purposes.

Information Value
Required No
Data type String

Data source JNDI name

The JNDI name of the data source that the messaging engine uses to access the relational database management system (RDBMS) for the data store.

Information Value
Required Yes
Data type Text

Schema name

The name of the database schema used to contain the tables for the data store.

Each messaging engine stores its resources, such as tables, in a single schema. Each database schema is used by one messaging engine only. Although every messaging engine uses the same table names, its relationship with the schema gives each messaging engine exclusive use of its own tables.
Information Value
Required No
Data type String

Authentication alias

The name of the authentication alias used by the messaging engine to access the data source.

Information Value
Required No
Data type drop-down list

Create tables

If this option is selected, the messaging engine creates the database tables for the data store automatically. Otherwise, the database administrator must create the database tables manually.

Information Value
Required No
Data type Boolean

Restrict long running locks

If this option is selected, A new messaging engine locking mechanism is applied, where long DB locks are not held. Otherwise, the old locking mechanism is applied where long DB locks are held by messaging engine.

When this option is selected, the messaging engine establishes a lock over the database only for short durations. In the event of the active messaging engine not responding to the database, the standby messaging engine will be able to take ownership of the database because the active messaging engine holds only short duration locks.

Information Value
Required No
Data type Boolean
Important: If you installed WebSphere® Application Server by using a version earlier than Version 8.5.5, use the sibDBUpgrade command to upgrade the database tables so that the option takes effect. For more information about upgrading database tables, see the topic on the sibDBUpgrade command.

Number of tables for permanent objects

Number of database tables to use for storage of permanent objects.

Information Value
Required No
Data type Integer
Range 1 through 30
Avoid trouble: Number of tables for permanent objects plus the number of tables for temporary objects plus 1 must be less than or equal to 32.

Number of tables for temporary objects

Number of database tables to use for storage of temporary objects.

Information Value
Required No
Data type Integer
Range 1 through 30
Avoid trouble: Number of tables for permanent objects plus the number of tables for temporary objects plus 1 must be less than or equal to 32.