WebSphere Business Integration Message 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 |