+

Search Tips   |   Advanced Search

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 information center 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

    This option ensures that the active messaging engine does not retain long running locks on the SIBOWNER table in the database.

    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: Although the property is selected, the property will not be effective until the database tables are upgraded using the sibDBUpgrade command for WebSphere Application Server v8.5 and later.

    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 2147483647

    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 2147483647


    Related Items

    JAAS - J2C authentication data

    List of user identities and passwords for Java 2 connector security to use.


    Related tasks

  • Configure a messaging engine to use a data store


    Related information:

  • Administrative console buttons

  • Administrative console preference settings Reference topic