Open topic with navigation

TIBCO iProcess® Engine 11.9.1

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

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine

Copyright © 1994-2024. Cloud Software Group, Inc. All Rights Reserved.