IBM BPM, V8.0.1, All platforms > Install IBM BPM > Plan for IBM BPM > Plan the database configuration

Supported database types

Choose a database depends on your operating system and on the features that you will use with IBM BPM.

See JDBC drivers for Express , Oracle, and SQL Server. For information about the JDBC drivers (including version and level information), see the web page Detailed hardware and software requirements for IBM BPM.

You are responsible for providing JDBC driver levels outside of what is packaged with IBM BPM.

The DB2 Express database is included in the IBM BPM software, and can be installed and configured automatically when you install IBM BPM The user must have administrative privileges (root or Administrator) to install DB2 Express.

If installing DB2 Express as a root user, you must ensure that all kernel requirements are met before the DB2 Express installation begins. See Kernel parameter requirements ( Linux ) for a list of the kernel requirements. You can locate the current values by parsing the output of the ipcs -l command.

Currently, there is a known limitation in DB2 Express installer related to the inclusion of national language (NL) strings in properties passed to it from the IBM BPM installer. The following values, which are passed to DB2 Express when it is being installed cannot have NL strings in them:

Choose passwords that comply with the password policy of your system (for example, Windows 2008).

Each database is represented by a parameter dbType which is a character string. The dbType parameter is used as a parameter in manageprofiles command-line utilityresponse files. The values of dbType for the supported databases are shown in DB2 Express DB2_UNIVERSAL Used as the default database type for a stand-alone profile.Used as the default database type for a stand-alone server. DB2 Universal

DB2_UNIVERSAL   DB2 Data Server

DB2_DATASERVER Available for download from:

DB2 for z/OS

DB2UDBOS390

If you are using DB2 for z/OS as your database management system, configure the database and database objects by using the createDB2.sh script. The installation wizard is not able to create a database of this type. You can use DB2 for z/OS for either ND or stand-alone server configurations.. Microsoft SQL Server Microsoft SQL Server JDBC 1.2 and 2.0 = MSSQLSERVER_MICROSOFT

Microsoft SQL Server JDBC 3.0 is also supported, though not listed as a separate database type on pmt.sh. If you are using Microsoft SQL Server JDBC 3.0 as your database management system, selecting. a database type of Microsoft SQL Server JDBC 2.0 will support version 3.0

The Process Server and Performance Data Warehouse databases cannot be shared in the CommonDB.

If a locale different from Latin must be specified, then the createDatabase.sql script must not be used. A different locale that is NOT case-sensitive must be specified.

You must configure XA transactions after the database is installed and before you start the server. Failure to configure the XA transactions can result in an error during server startup. Oracle

ORACLE The installation wizard is not able to create a database of this type for Oracle.

IBM BPM requires the national character set to be UTF8, based on the following recommendation from Oracle: The maximum column size allowed is 4000 characters when the national character set is UTF8 and 2000 when it is AL16UTF16. The maximum length of an NVARCHAR2 column in bytes is 4000. Both the byte limit and the character limit must be met, so the maximum number of characters that is actually allowed in an NVARCHAR2 column is the number of characters that can be written in 4000 bytes. For details, refer to the following Oracle information: http://www.oracle.com/technetwork/database/globalization/dmu/overview/index.html

A second parameter used in file path and file naming conventions is feature, which indicates which of the various databases is under consideration. Table 2 lists the databases and the associated feature parameter.

Databases and their associated feature name.
Database Feature
Business Process Choreographer ProcessChoreographer
Business Space BusinessSpace
Process Server ProcessServer
Performance Data Warehouse PerformanceDW
Common database CommonDB
Enterprise service bus logger mediation database EsbLoggerMediation

When you install IBM Business Process Manager, database scripts are created in the following locations:

 INSTALL_ROOT/dbscripts/ feature/ dbType
Where feature can be:

This applies to the common database and the Business Process Choreographer database. The Enterprise service bus Logger Mediation (EsbLoggerMediation) database uses the location:

/WebSphere/V8R0/AppServer/util/EsbLoggerMediation/ dbType

The creation of most JDBC providers is performed during profile creation, during configuration, based upon the database parameters that you provide. However, the Business Process Choreographer JDBC providers may be created later using scripts or the administrative console. If a suitable JDBC provider is located on the server or cluster, the existing JDBC provider is used and the creation of a new one is omitted.

Plan the database configuration


Related concepts:
JDBC drivers and locations


Related information:

Use a DB2 database to hold custom user registry data