IBM BPM, V8.0.1, All platforms > Install IBM BPM > Plan for IBM BPM > Plan the database configuration
Database naming restrictions
Databases cannot be reused across multiple installations of IBM BPM. Each installation of IBM BPM requires exclusive use of its associated databases. You must configure the databases so that they can be uniquely identified.
Depending on the installation path that you select, the databases associated with an installation might be configured with default names.
For example, the databases associated with IBM BPM Advanced on IBM DB2 have the following defaults:
- Process Server - BPMDB
- Performance Data Warehouse - PDWDB
If you have two installations of IBM BPM Advanced that use DB2, you must select, for one of the installations, an installation path that lets you specify the names instead of accepting the default values.
To ensure the uniqueness of the database names, select installation paths that prompt you for the database names.
For example, you are prompted for the database names when you use the Typical installation path. Select the option to use an existing database server instead of the default DB2 Express.
When you use pmt.sh to create a profile after installation, you are prompted for database names, no matter which path in pmt.sh (Typical or Advanced) you choose. The only exception is when you use a database design file for your database configuration. The database design file contains the database names, user name, and password information. Thus, pmt.sh does not prompt you for this information.
In contrast, you are not prompted for database names in the following cases:
- You are using the Custom installation path for the IBM BPM Advanced Process Server image. Installation Manager provides an option to create the profile, but assigns default values to the database names.
- You are using the Typical installation path and you choose to install DB2 Express, which is packaged with the installation images. Database names are assigned the default values.
Additional restrictions apply to database naming. These restrictions depend on the database server that you are using.
IBM BPM Advanced Advanced installation
For IBM DB2 and Microsoft SQL Server databases, the following restrictions apply:
- The Process Server, Performance Data Warehouse, and Common database components must be in separate databases.
- The Process Server and Performance Data Warehouse components do not support case-sensitive databases. These databases must NOT be case-sensitive.
For Microsoft SQL Server databases, components other than Process Server or Performance Data Warehouse require that their databases be case-sensitive.
For Oracle databases, the Process Server, Performance Data Warehouse, and Common database components must use a separate schema/user. They can use the same instance.