Creating a DB2 Database

Status

If you are...

This task is...

Installing a new iProcess Engine Version 11.8.0

Required

Upgrading from an iProcess Engine Version 11.0 or later

N/A

Database

DB2

Description

You must create an empty DB2 database to hold iProcess data before you install iProcess Engine. The installer will populate this database with the necessary iProcess data.

Warning 

If you intend to use the SQL Explain facility with the iProcess Engine database, you must ensure that the iProcess Engine DB Schema Owner account (see Creating iProcess Engine UNIX Users and Groups) has the necessary permissions to create and write to the Explain tables.

If the account does not have these permissions, the installer will not be able to create the iProcess Engine stored procedures when it populates the database. Any application that uses these stored procedures, such as the TIBCO iProcess Web Services Plug-in, will not work.

See your DB2 documentation for more information about explain tables and how to grant create or write access to them.

Procedure

To create the database:

1. Log in as a user who has the necessary permissions to create a database in the $DB2INSTANCE instance.
2. Make sure that $DB2INSTANCE points to the correct instance.
3. Use the following DB2 command to create the database:

db2 create database db_name

where db_name is the name you want to use for the iProcess Engine database.

Give the iProcess Engine DB Schema Owner account the necessary permissions to create and write to any Explain tables on the database.

See Also

See your DB2 documentation for detailed information about how to create a database and the CREATE DATABASE command.