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