Configure Databases

Use this page to configure the database supporting the deployment environment and to create the tables in the database that are a part of the deployment environment.

The page displays and allows you to configure all of the data sources that are part of the deployment environment. You can choose to create tables by selecting Create Tables. If you choose not to create the tables with the wizard you must run the table creation scripts separately.

Select provider
Select a database for the deployment environment. The options displayed on the page depend on the database type that you select from the Select provider list.

Links marked (online) require access to the Internet.

Check for updates to this topic (online)

Options for DB2

The following options are available for a DB2 database.

User name
Specifies a user ID with sufficient authorization to access or update the rows in the database.
Password
Specifies the correct password associated with User name that permit successful access to the database.
Confirm password
Specifies a confirmation check for the correct password associated with User name.
Server
Specifies the server on which the database subsystem resides.
Port
Specify the port for the database subsystem.
Create Tables
Specifies whether to create tables within the database during configuration. To defer table creation, clear the check box.
cellDB
Specifies configurations for the cell database.
Note: This option is available for the first advanced deployment environment that you create.
  • Name: Specifies a name for the cell database.
Common database
Specifies configurations for the common database which is used for CommonDB components, Business Space, Business Process Choreographer, and Messaging.
Note: This option is available only for BPM Advanced Process Center, BPM Advanced Process Server, and BPM Advanced-only Process Server deployment environments.
  • Name: Specifies a name for the common database.
Process database
Specifies configurations for the Process database.
Note: This option is not available for BPM Advanced-only Process Server deployment environment.
  • Name: Specifies a name for the Process database.
Performance Data Warehouse database
Specifies configurations for the Performance Data Warehouse database.
Note: This option is not available for BPM Advanced-only Process Server deployment environment.
  • Name: Specifies a name for the Performance Data Warehouse database.
Select the databases that you want to separate from the Common database.
Specifies options to configure a separate database for the messaging database and the Business Process Choreographer database.
Messaging
Select this to create a separate messaging database and specify the following information.
  • Name: Specifies a name for the messaging database.
Business Process Choreographer
Select this to create a separate Business Process Choreographer database and specify the following information.
Note: This option is available only for the BPM Advanced Process Center, BPM Advanced Process Server, and BPM Advanced-only Process Server deployment environments.
  • Name: Specifies a name for the Business Process Choreographer database.
Test connection
Click to verify that the database can be accessed using the values you specified on this page.

Options for DB2 on z/OS

The following options are available for a DB2 on z/OS database.

User name
Specifies a user ID with sufficient authorization to access or update the rows in the database. When you select Create Tables the authorization must include the ability to create tables and create schemas.
Password
Specifies the correct password associated with User name that permit successful access to the database.
Confirm password
Specifies a confirmation check for the correct password associated with User name.
Server
Specifies the server on which the database resides.
Port
Specifies the port for the database.
Database connection location
Specifies the database connection location.
Storage group
Specifies the storage group for the tables.
Volume Catalog
Specifies the volume catalog for the database.
Buffer pool of 4k size
Specifies the name of the buffer pool with the size as 4k.
Index buffer pool
Specifies the name of the index buffer pool.
LOB buffer pool
Specifies the name of the LOB buffer pool.
Buffer pool of 8k size
Specifies the name of the buffer pool with the size as 8k.
Buffer pool of 16k size
Specifies the name of the buffer pool with the size as 16k.
Buffer pool of 32k size
Specifies the name of the buffer pool with the size as 32k.
cellDB
Specifies configurations for the cell database.
Note: This option is available for the first advanced deployment environment that you create.
  • Name: Specifies a name for the cell database.
  • Schema name: Specifies a name for the schema.
Common database
Specifies configurations for the common database.
Note: This option is available only for BPM Advanced Process Center, BPM Advanced Process Server, and BPM Advanced-only Process Server deployment environments.
  • Name: Specifies a name for the common database.
  • Schema name: Specifies a name for the schema.
Process database
Specifies configurations for the Process database.
Note: This option is not available for BPM Advanced-only Process Server deployment environment.
  • Name: Specifies a name for the Process database.
  • Schema name: Specifies a name for the schema.
Performance Data Warehouse database
Specifies configurations for the Performance Data Warehouse database.
Note: This option is not available for BPM Advanced-only Process Server deployment environment.
  • Name: Specifies a name for the Performance Data Warehouse database.
  • Schema name: Specifies a name for the schema.
Select the databases that you want to separate from the Common database.
Specifies options to configure a separate database for the messaging database and the Business Process Choreographer database.
Messaging
Select this to create a separate messaging database and specify the following information.
  • Name: Specifies a name for the messaging database.
  • Schema name: Specifies a name for the schema.
Business Process Choreographer
Select this to create a separate Business Process Choreographer database and specify the following information.
Note: This option is available only for the BPM Advanced Process Center, BPM Advanced Process Server, and BPM Advanced-only Process Server deployment environments.
  • Name: Specifies a name for the Business Process Choreographer database.
  • Schema name: Specifies a name for the schema.
Test connection
Click to verify that the database can be accessed using the values you specified on this page.

Options for Oracle

The following options are available for an Oracle database.

Server
Specifies the server on which the database resides.
Port
Specifies the port for the database.
Instance name
Specifies the schema name for accessing the database.
Create Tables
Specifies whether to create tables within the database during configuration. To defer table creation, clear the check box.
cellDB
Specifies configurations for the cell database.
Note: This option is available for the first advanced deployment environment that you create.
  • Name: Specifies a name for the cell database.
  • Password: Specifies the password for the user.
  • Confirm password: A password check to confirm the password associated with User name.
Common database
Specifies configurations for the common database.
Note: This option is available only for BPM Advanced Process Center, BPM Advanced Process Server, and BPM Advanced-only Process Server deployment environments.
  • User name: Specifies a user name for the common database.
  • Password: Specifies the password for the user.
  • Confirm password: A password check to confirm the password associated with User name.
Process database
Specifies configurations for the Process database.
Note: This option is not available for BPM Advanced-only Process Server deployment environment.
  • User name: Specifies a user name for the Process database.
  • Password: Specifies the password for the user.
  • Confirm password: A password check to confirm the password associated with User name.
Performance Data Warehouse database
Specifies configurations for the Performance Data Warehouse database.
Note: This option is not available for BPM Advanced-only Process Server deployment environment.
  • User name: Specifies a user name for the Performance Data Warehouse database.
  • Password: Specifies the password for the user.
  • Confirm password: A password check to confirm the password associated with User name.
Select the databases that you want to separate from the Common database.
Specifies options to configure a separate database for the messaging database and the Business Process Choreographer database.
Messaging
Select this to create a separate messaging database and specify the following information.
  • User name: Specifies a name for the messaging database.
  • Password: Specify the password for the user.
  • Confirm password: A password check to confirm the password associated with User name.
Business Process Choreographer
Select this to create a separate Business Process Choreographer database and specify the following information.
Note: This option is available only for the BPM Advanced Process Center, BPM Advanced Process Server, and BPM Advanced-only Process Server deployment environments.
  • User name: Specifies a name for the Business Process Choreographer database.
  • Password: Specify the password for the user.
  • Confirm password: A password check to confirm the password associated with User name.
Test connection
Click to verify that the database can be accessed using the values you specified on this page.

Options for Microsoft SQL Server using Windows Authentication

The following options are available for a Microsoft SQL Server database using Windows Authentication.

Server
Specifies the server on which the database resides.
Port
Specifies the port for the database.
Create Tables
Specifies whether to create tables within the database during configuration. To defer table creation, clear the check box.
cellDB
Specifies configurations for the cell database.
Note: This option is available for the first advanced deployment environment that you create.
  • Name: Specifies a name for the cell database.
Common database
Specifies configurations for the common database.
Note: This option is available only for BPM Advanced Process Center, BPM Advanced Process Server, and BPM Advanced-only Process Server deployment environments.
  • Name: Specifies a name for the common database.
Process database
Specifies configurations for the Process database.
Note: This option is not available for BPM Advanced-only Process Server deployment environment.
  • Name: Specifies a name for the Process database.
Performance Data Warehouse database
Specifies configurations for the Performance Data Warehouse database.
Note: This option is not available for BPM Advanced-only Process Server deployment environment.
  • Name: Specifies a name for the Performance Data Warehouse database.
Select the databases that you want to separate from the Common database.
Specifies options to configure a separate database for the messaging database and the Business Process Choreographer database.
Messaging
Select this to create a separate messaging database and specify the following information.
  • User name: Specifies a name for the messaging database.
Business Process Choreographer
Select this to create a separate Business Process Choreographer database and specify the following information.
Note: This option is available only for the BPM Advanced Process Center, BPM Advanced Process Server, and BPM Advanced-only Process Server deployment environments.
  • User name: Specifies a name for the Business Process Choreographer database.
Test connection
Click to verify that the database can be accessed using the values you specified on this page.

Options for Microsoft SQL Server without Windows Authentication

The following options are available for a Microsoft SQL Server database without Windows Authentication.

User name
Specifies a user ID with sufficient authorization to access or update the rows in the database. When you select Create Tables the authorization must include the ability to create tables and create schemas.
Password
Specifies the correct password associated with User name that permit successful access to the database.
Confirm password
A password check to confirm the password associated with User name.
Server
Specifies the server on which the database resides.
Port
Specifies the port for the database.
Create Tables
Specifies whether to create tables within the database during configuration. To defer table creation, clear the check box.
cellDB
Specifies configurations for the cell database.
Note: This option is available for the first advanced deployment environment that you create.
  • Name: Specifies a name for the cell database.
Common database
Specifies configurations for the common database.
Note: This option is available only for BPM Advanced Process Center, BPM Advanced Process Server, and BPM Advanced-only Process Server deployment environments.
  • Name: Specifies a name for the common database.
Process database
Specifies configurations for the Process database.
Note: This option is not available for BPM Advanced-only Process Server deployment environment.
  • Name: Specifies a name for the Process database.
Performance Data Warehouse database
Specifies configurations for the Performance Data Warehouse database.
Note: This option is not available for BPM Advanced-only Process Server deployment environment.
  • Name: Specifies a name for the Performance Data Warehouse database.
Select the databases that you want to separate from the Common database.
Specifies options to configure a separate database for the messaging database and the Business Process Choreographer database.
Messaging
Select this to create a separate messaging database and specify the following information.
  • User name: Specifies a name for the messaging database.
Business Process Choreographer
Select this to create a separate Business Process Choreographer database and specify the following information.
Note: This option is available only for the BPM Advanced Process Center, BPM Advanced Process Server, and BPM Advanced-only Process Server deployment environments.
  • User name: Specifies a name for the Business Process Choreographer database.
Test connection
Click to verify that the database can be accessed using the values you specified on this page.