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.

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.

Procedure

Use one of the following methods to create the BPMDB and PDWDB databases:
- Create and run the createDatabase_CaseInsensitive.sql file as described in the following substeps:
  1. Save the following SQL statement into a file named createDatabase_CaseInsensitive.sql (where CI in the COLLATE attribute value is applicable for the case-insensitive databases):
```
CREATE DATABASE @DB_NAME@ COLLATE SQL_Latin1_General_CP1_CI_AS;
```
  2. In the SQL statement, replace @DB_NAME@ with the name of the database that you want to create.
  3. Run the following command to create the database:
```
sqlcmd -i createDatabase_CaseInsensitive.sql
```
- Run the following command from the command line (where @DB_NAME@ is the name of the database that you want to create):
```
sqlcmd -Q "CREATE DATABASE @DB_NAME@ COLLATE SQL_Latin1_General_CP1_CI_AS"
```
Use one of the following methods to create the CMNDB database:
- Create and run the createDatabase_CaseSensitive.sql file as described in the following substeps:
  1. Save the following SQL statement into a file named createDatabase_CaseSensitive.sql (where CS in the COLLATE attribute value is applicable for the case-sensitive databases):
```
CREATE DATABASE @DB_NAME@ COLLATE SQL_Latin1_General_CP1_CS_AS;
```
  2. In the SQL statement, replace @DB_NAME@ with the name of the database that you want to create.
  3. Run the following command to create the database:
```
sqlcmd -i createDatabase_CaseSensitive.sql
```
- Run the following command from the command line (where @DB_NAME@ is the name of the database that you want to create):
```
sqlcmd -Q "CREATE DATABASE @DB_NAME@ COLLATE SQL_Latin1_General_CP1_CS_AS"
```