Planning the number of databases
To edit the BPMConfig properties file as required, you must know the number of databases that must be set up for a shared or an unshared database environment, for either a new installation or a migration from IBM Business Process Manager. The number of databases can be adjusted based on the configuration of your deployment environment.
Databases are different from database schemas. Database schemas can share the same database. Business Automation Workflow components such as Messaging, BusinessSpace, and ProcessServer are assigned to database schemas. When no name conflicts occur between database objects, components can share the same database. Components such as Process Server and Performance Data Warehouse (PDW) do not have database schema support; therefore, they cannot share the same database.
Database | Schema | Components |
---|---|---|
CMNDB (the common database) | SharedDB | Messaging (Messaging Engine), FEM (Failed Event Manager), BusinessSpace (BSpace), Business Process Choreographer (BPC), and Event Sequencing |
CellOnlyDB | Application scheduler (AppSched), Mediations (Meds), Relationship manager (Rels), Enterprise Service Bus Logger Mediation (ESBLogMed), and Customization (Business Rules and Selectors) | |
BPMDB (the Process database) | ProcessServerDB | Workflow Server (ProcessServer) (and BPM content store (EmbeddedECM) |
PDWDB (the Performance Data Warehouse database) | PerformanceDB | Performance Data Warehouse |
CPEDB (the Content database) | DosDb | Design Object Store |
TosDb | Target Object Store | |
CaDb | Case Analyzer Object Store | |
ChDb | Case History Object Store | |
ICNDb | IBM® Content Navigator |
- The CellOnlyDB schema exists only in the Advanced and AdvancedOnly deployment environments, and is part of the CMNDB database by default.
- If you configured an Express deployment environment, the default configuration uses two databases, BPMDB and PDWDB.
- If you configured an AdvancedOnly deployment environment, the default configuration uses one database, CMNDB, with the corresponding database schemas (CellOnlyDB and SharedDB) and assigned components.