Data store tables

Data store tables

A data store uses an RDBMS, working through JDBC, to store data as rows in a set of tables.
Use these tables to back up or restore a SIB data.

Table Purpose
SIBOWNER Ensures exclusive access to the data store by an active messaging engine.
SIBOWNERO Used for locking the data store. This table stores no data in its one EMPTY_COLUMN column.
SIBCLASSMAP Catalogs the different object types in the data store.
SIBLISTING Catalogs the SIBnnn tables.
SIBXACTS Maintains the status of active two-phase commit transactions.
SIBKEYS Assigns unique identifiers to objects in the messaging engine.
SIBnnn Contains 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. nnn is a number.

The SIBOWNERO table was introduced for WAS V7.0 and must be created when we are migrating to WAS V7.0 from an earlier version of WAS.

Last updated Dec 15, 2010 8:14:22 PM CST

Table	Purpose
SIBOWNER	Ensures exclusive access to the data store by an active messaging engine.
SIBOWNERO	Used for locking the data store. This table stores no data in its one EMPTY_COLUMN column.
SIBCLASSMAP	Catalogs the different object types in the data store.
SIBLISTING	Catalogs the SIBnnn tables.
SIBXACTS	Maintains the status of active two-phase commit transactions.
SIBKEYS	Assigns unique identifiers to objects in the messaging engine.
SIBnnn	Contains 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. nnn is a number.