Administer data stores

A data store is a type of message store that uses a relational database. A data store consists of a set of tables that are in the same database schema. It is used by a messaging engine to store operating information in the database, as well as to preserve essential objects that the messaging engine needs for recovery in the event of a failure.

A data store consists of the set of tables that a messaging engine uses to store persistent data in a database. See Data store tables for a list of the tables that comprise a data store. All the tables in a data store are held in the same database schema. We can create multiple data stores in the same database, provided that you use a different schema name for each data store.

Subtopics

• Configure a messaging engine to use a data store
  Although the default message store for a typical messaging engine is file store, we can also configure a messaging engine to use a data store.

• Back up and restoring a messaging engine data store
  Administering the data store for a messaging engine includes restoring and backing up the data store.

• Emptying the data store for a messaging engine
  By emptying the data store of a messaging engine, we can discard persistent operating information without deleting the messaging engine.

• Share connections to benefit from one-phase commit optimization
  In some circumstances, we can configure the JMS application to share the JDBC connection that a messaging engine uses. Sharing connections enables you to use one-phase commit optimization. This can improve the performance of the application.

• Configure messaging engine and server behavior when a data store connection is lost
  If the connection between a running messaging engine and its data store is lost, either due to a failure or because you stop the database for maintenance, we can ensure that the messaging engine functions correctly after the connection is restored, by configuring the server to restart automatically.

• Data store tables
  A data store uses a relational database management system (RDBMS), working through JDBC, to store data as rows in a set of tables. This data is important when we are backing up or restoring a data store.

• Altered database tables
  A data store uses a relational database management system (RDBMS), working through JDBC, to store data as rows in a set of tables. A few of the database tables are altered as a result of running the sibDBUpgrade command.

• Database privileges
  In order for a messaging engine to use its data store, the database user ID that the messaging engine uses must have sufficient privilege to enable the messaging engine to access the data store tables. The messaging engine to create the data store tables automatically, the messaging engine user ID requires additional privileges.

Subtopics

• Configure a messaging engine to use a data store
  Although the default message store for a typical messaging engine is file store, we can also configure a messaging engine to use a data store.

• Back up and restoring a messaging engine data store
  Administering the data store for a messaging engine includes restoring and backing up the data store.

• Emptying the data store for a messaging engine
  By emptying the data store of a messaging engine, we can discard persistent operating information without deleting the messaging engine.

• Share connections to benefit from one-phase commit optimization
  In some circumstances, we can configure the JMS application to share the JDBC connection that a messaging engine uses. Sharing connections enables you to use one-phase commit optimization. This can improve the performance of the application.

• Configure messaging engine and server behavior when a data store connection is lost
  If the connection between a running messaging engine and its data store is lost, either due to a failure or because you stop the database for maintenance, we can ensure that the messaging engine functions correctly after the connection is restored, by configuring the server to restart automatically.

• Data store tables
  A data store uses a relational database management system (RDBMS), working through JDBC, to store data as rows in a set of tables. This data is important when we are backing up or restoring a data store.

• Altered database tables
  A data store uses a relational database management system (RDBMS), working through JDBC, to store data as rows in a set of tables. A few of the database tables are altered as a result of running the sibDBUpgrade command.

• Database privileges
  In order for a messaging engine to use its data store, the database user ID that the messaging engine uses must have sufficient privilege to enable the messaging engine to access the data store tables. The messaging engine to create the data store tables automatically, the messaging engine user ID requires additional privileges.