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.
When 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.
You 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.
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 |