Business Process Choreographer database specifications

The Business Process Choreographer requires a database. The Business Process Choreographer database (BPEDB) is used for this purpose.

The Business Process Choreographer database is only used by Business Process Choreographer.

Supported database types

The following databases are supported for use as the Business Process Choreographer database:
  • Cloudscape™ V5.1
    • Cloudscape JDBC Provider (XA)
      Note: Cloudscape is not supported as the Business Process Choreographer database in a network deployment environment.
  • DB2 Universal Database™ V8.1 and V8.2
    • DB2® Legacy CLI-based Type 2 JDBC Driver (XA)
    • DB2 Universal JDBC Driver Provider (XA)
  • DB2 Universal Database for OS/390® V7 and V8
    • DB2 Legacy CLI-based Type 2 JDBC Driver (XA)
    • DB2 Universal JDBC Driver Provider (XA)
  • Informix® v9.4 and v10.0
    • Informix JDBC Driver (XA)
  • SQL Server 2000
    • WebSphere® embedded ConnectJDBC driver for MS SQL Server (XA)
    • DataDirect ConnectJDBC type 4 driver for MS SQL Server (XA)
  • Oracle V9i and 10g
    • Oracle JDBC Driver (XA)
Important: Cloudscape is used for the Business Process Choreographer Sample configuration, which you can create when creating or augmenting a stand-alone server profile. The network JDBC driver for Cloudscape is not supported, because it has no XA support.

Database Management Service (DBMS) instances

Each deployment target (either server or cluster) can be configured to support Business Process Choreographer applications. Each Business Process Choreographer deployment target must have its own database. Databases cannot be shared between deployment targets.

Configuration actions during profile creation

Configuring the Business Process Choreographer database can be complex and requires many parameters. Therefore, it is performed as a post profile creation step. The Business Process Choreographer Sample configuration, which can be set up when creating or augmenting a stand-alone server profile through the Profile wizard, is based on Cloudscape and requires a minimal set of parameters. However, it is not suitable for production purposes.

The Business Process Choreographer Sample configuration cannot be created under other circumstances since Cloudscape is not supported by the Business Process Choreographer database in network deployment environments. When you select the Business Process Choreographer Sample configuration option, the Profile wizard invokes the standard Business Process Choreographer configuration script (bpeconfig.jacl) with the appropriate parameters, which you must supply. This script creates the Cloudscape database for the sample configuration.

SQL scripts

All the scripts to create and manage the Business Process Choreographer database can be found in the directory install_root/dbscripts/ProcessChoreographer/dbType. These scripts are described in detail in Using scripts to administer Business Process Choreographer.

There are scripts to create the database (for simple setups), to create tablespaces, dbspaces, and the schema (for advanced setups), to clear the schema, to drop the schema, and to drop the tablespaces or dbspaces. These scripts can either be run manually by a database administrator or you can run the bpeconfig.jacl script, which will invoke the scripts for you.

JDBC provider

If an appropriate JDBC provider does not exist one is created.

The data source name is:

BPEDataSourcedbType

The data source JNDI name is:

jdbc/BPEDB

Restrictions

The Create new (local) database option is disabled for the following database types.
  • DB2 Universal Database for z/OS and OS/390 V7.1 (DB2UDBOS390_V7_1)
  • DB2 Universal Database for z/OS V8.1 (DB2UDBOS390_V8_1)
  • Oracle OCI client (ORACLE_OCI)
  • Oracle Thin (ORACLE_THIN)
Cloudscape is not supported in network deployment environments.

Tables

Many tables are created. See the generated scripts to see which tables are generated for the given database product.

Exported scripts

Business Process Choreographer does not export any scripts. All scripts needed to configure the Business Process Choreographer database are deployed as part of the product installation to the:
install_root/dbscripts/ProcessChoreographer/dbType
directory.

User ID privileges

The user credentials that you provide in the Profile wizard must have the permissions necessary to create tablespaces, tables, indexes, and stored procedures. For the Create a new (local) database option, the user identity must have the necessary privileges to create a new database.


Last updated: Wed 01 Nov 2006 07:47:12

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)