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 in the same database schema. It is used by a messaging engine to store operating information in the database, and 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 we use a different schema name for each data store.

Subtopics

• Configure a messaging engine to use a data store
  
• Back up and restore a messaging engine data store
  
• Emptying the data store for a messaging engine
  
• Sharing connections to benefit from one-phase commit optimization
  
• Configure messaging engine and server behavior when a data store connection is lost
  
• Data store tables
  
• Altered database tables
  
• Database privileges