Database contents

WebSphere Business Integration Event Broker stores configuration and resource information in databases to retain the information and ensure its security and integrity. The Configuration Manager and each broker create and maintain information in tables specifically created for that purpose.

When you create a broker, the mqsicreatebroker command creates a number of database tables within the database that you specify in the command. You can specify a different database for every broker, or share a database between brokers. The database tables schema inherits its name from the Data Source User ID specified in the create command.

The table below shows the database tables that are created by the mqsicreatebroker command in the broker database. The tables are created when you create the first broker. When you create further brokers specifying the same database, new rows are created for each broker. Every row created in the table includes the broker name, therefore each row is unique to a single broker.

Table name Description
BAGGREGATE Aggregate flow control information
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

The next table shows the tables that are created by the mqsicreateconfigmgr command in the configuration repository database. There is a single set of these tables because there is a single Configuration Manager, and therefore a single configuration repository, in a broker domain.

Table name Description
CACLGROUPS ACL groups
CBROKER Broker details
CBROKERCEG Execution group to broker mapping information
CCICSADAPTER Not used currently
CCMDFCTYPE Not used currently
CCOLLECTIVE Collectives details
CCOLLECTIVECBROKER Collective to broker relationships
CDATACTXTFCTYPE Not used currently
CDECFCTYPE Not used currently
CDELETED Deleted resources
CEG Execution group details
CEGCMSGFLOW Message flow mapping information
CEGCMSGPROJECT Message set mapping information
CITERFCTYPE Not used currently
CLOG Event messages
CMSGFLOW Message flow details
CMSGPROJECT Message set details
CNAVTYPE Not used currently
CNEIGHBOURS Broker neighbor topology details
COUTSTANDING Actions with outstanding responses
CPRIMITIVES Primitive message processing node details
CPROPERTIES UUID properties
CPROXY Proxy identifiers
CPROXYRESOURCE Resources associated with the proxy
CSRCADAPTER Not used currently
CSUBSCRIBE Subscriber information
CTGTADAPTER Not used currently
CTOPIC Set of all topics available in the broker domain
CTOPICCTOPIC Topic tree mapping information
CTOPOLOGY Topology details
CTRACE Persistent trace information
CUUIDLOCKS Locking information
Related tasks
Backing up resources
Related reference
mqsicreatebroker command
mqsicreateconfigmgr command