Data store tables

This topic describes the tables that are held in the messaging engine data store. These tables are important when backing up or restoring a data store.

Table name Purpose
SIBOWNER Ensure exclusive access to the data store by an active messaging engine
SIBCLASSMAP Catalogs the different object types in the data store
SIBLISTING Catalogs the SIBnnn tables
SIBXACTS Maintain the status of active two-phase commit transactions
SIBKEYS Assign unique identifiers to objects in the messaging engine
SIBnnn, where nnn is a number Contain persistent objects such as messages and subscription information

These tables hold both persistent and nonpersistent objects, using separate tables for the different types of data, according to the following convention:

  • SIB000 contains information about the structure of the data in the other two tables
  • SIB001 contains persistent objects
  • SIB002 contains nonpersistent objects that have been saved to the data store to reduce the messaging engine memory requirement



Related tasks
Creating the tables
Enabling your database administrator to create the data store tables
Reference topic    

Terms of Use | Feedback

Last updated: Aug 29, 2010 10:43:27 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=v602web&product=was-nd-mp&topic=rjm0640
File name: rjm0640_.html