Database contents

WebSphere® Event Broker stores configuration and resource information in databases to retain the information and ensure its security and integrity. Each broker creates and maintains information in tables specifically created for that purpose.

Start of changeWhen you create a broker, the mqsicreatebroker command creates a number of database tables within the database that you specify in the command. The database schema is created, if it does not already exist, based on the user ID you specify on the command, and the tables are created if they do not already exist. End of change

Start of changeYou can specify parameters that create a different database schema for every broker, or share a database schema between brokers. If you create further brokers that specify the same database schema, new rows are created for each broker. Every row that is created in the table is qualified by a unique identifier (UUID) for each broker, therefore each row is unique to a single broker.End of change

The following table shows the database tables that are created by the mqsicreatebroker command in the broker database schema.

Table name Description
BACLENTRIES ACL entries
BCLIENTUSER Maps client identifiers to durable subscriptions
BGROUPNAME Publish/subscribe principals: groups
BMQEPUBDEST Contains list of WebSphere MQ Everyplace® queues on which messages can be placed
BMQEPUBMSGIN Holds persistent WebSphere MQ Everyplace publish/subscribe messages waiting to be processed by the broker
BMQEPUBMSGOUT Holds persistent WebSphere MQ Everyplace publish/subscribe to be placed on an WebSphere MQ Everyplace queue
BMQESTDMSGIN Holds persistent WebSphere MQ Everyplace non-publish/subscribe messages waiting to be processed by the broker
BMQESTDMSGOUT Holds persistent messages to be sent to WebSphere MQ Everyplace destinations
BMQPSTOPOLOGY Publish/subscribe neighbor information
BMULTICASTTOPICS Multicast topics records
BNBRCONNECTIONS Inter-broker neighbor connection information
BPUBLISHERS Registered publishers
BRETAINEDPUBS Retained publications
BRMINFO Registered resource managers
BRMPHYSICALRES Physical resources
BRMRTDDEPINFO Runtime dictionary dependency values
BRMRTDINFO Registered runtime dictionaries
BRMWFDINFO Registered wire format descriptors
BROKERAA Broker process details to support recovery
BROKERAAEG Execution group details to support recovery
BROKERRESOURCES Broker resources
BSCADADEST Contains list of SCADA clients to which messages can be sent
BSCADAMSGIN Holds persistent SCADA messages waiting to be processed by the broker
BSCADAMSGOUT Holds persistent messages to be sent to SCADA destinations
BSUBSCRIPTIONS Durable subscription information
BTOPOLOGY Inter-broker neighbor information
BUSERCONTEXT Maps client identifiers to context information
BUSERMEMBERSHIP Publish/subscribe principals: membership
BUSERNAME Publish/subscribe principals: users
Related tasks
Backing up resources
Configuring broker databases
Related reference
Supported databases
mqsicreatebroker command
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2009Copyright IBM Corporation 1999, 2009. All Rights Reserved.
Last updated : 2009-01-07 15:40:48

an20140_