Creating SQL Server databases
You must create the required
databases before you install IBM® Business Process Manager. Usually
you require the Process database, the Performance Data Warehouse database,
and the Common database. In the case of
an Advanced-only deployment environment, you need only the Common
database.
Before you begin
- You cannot share databases across multiple installations or deployment environments.
- The Process Server and Performance Data Warehouse components require their own separate databases and cannot be configured on the same database as the other IBM Business Process Manager components.
- The Process Server and Performance Data Warehouse components require the databases to be case insensitive for SQL Server.
- The CommonDB (and legacy WebSphere® Process Server) components require the databases to be case sensitive for SQL Server.
- The user who creates the databases cannot be the same user that you plan to assign as the login user for accessing the databases. If you deviate from this requirement, the default schema dbo will be used.
- The schema name used for each component should match the user.
About this task
The default database names are BPMDB for the Process database, PDWDB for the Performance Data Warehouse database, and CMNDB for the Common database. In the case of an Advanced or Advanced-only deployment environment, the Common database has two parts: one is scoped to the cell and the other is scoped to the deployment environment. Both parts can be defined to use CMNDB (which is the default) or they can use separate databases.