Supported database types

Choosing a database depends on your operating system and on the features that you will use with IBM® Business Process Manager.

See Table 1 for a list of the databases that are supported with IBM Business Process Manager.

IBM Business Process Manager packages JDBC drivers for DB2, 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 Business Process Manager.

Note: You are responsible for providing JDBC driver levels outside of what is packaged with IBM Business Process Manager.

The DB2 Express database is included in the IBM Business Process Manager software, and can be installed and configured automatically when you install IBM Business Process Manager. To install DB2 Express, you must have administrative privileges (Administrator or root user) and must not have an existing DB2 database server on the system.

Important: If you are 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.

Note: 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 Business Process Manager installer. The following values, which are passed to DB2 Express when it is being installed cannot have NL strings in them:

Instance user name and password: bpminst and bpminst1
Fenced user name and password: bpmfenc and bpmfenc1
Administration server (DAS) user name and Password: bpmadmin and bpmadmin1
Administrative user name and Password: bpmadmin and bpmadmin1

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 utility. The values of dbType for the supported databases are shown in Table 1.

Table 1. Supported database types, their associated dbType values and restrictions
Supported database	dbType value	Restrictions and notes
DB2 Express	DB2_UNIVERSAL	Used as the default database type for a stand-alone profile.
DB2® Universal	DB2_UNIVERSAL
DB2 Data Server	DB2_DATASERVER	Available for download from: 9.7 GA level Fixpacks
DB2 for z/OS	DB2UDBOS390	If you are using DB2 for z/OS as your database management system, you must configure the database and database objects by using the `createDB.sh` script. The installation wizard is not able to create a database of this type. .
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 the Profile Management Tool. 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 Business Process Choreographer Explorer reporting function does not support this database type. Note: The Process Server and Performance Data Warehouse databases cannot be shared in the CommonDB. Note: If a locale different from Latin must be specified, then the `createDatabase.sql` script can not be used. A different locale that is case-insensitive must be specified. Important: 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 start up. See Configuring XA transactions.
Oracle	ORACLE	The installation wizard is not able to create a database of this type for Oracle.

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.

Table 2. 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:

BusinessSpace
CommonDB
EsbLoggerMediation
ProcessChoreographer
ProcessServer
PerformanceDW

The creation of most JDBC providers is performed during profile creation, 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.