IBM Support

Prerequisites for using an existing DB2 database with a typical installation

Troubleshooting


Problem

To use the existing database option during a typical installation of IBM Business Process Manager, you must ensure that your DB2 database already exists and that the database configuration meets certain requirements.

Cause

During a typical installation, you need to specify, on the Database page, the user name and password for database authentication, the database server host name and port, and the Process Server and Performance Data Warehouse databases. For IBM Business Process Manager Advanced, you also need to specify the Common database.

Environment

The information in this note applies to IBM Business Process Manager Express, IBM Business Process Manager Standard, IBM Business Process Manager Advanced, and IBM Business Process Manager Advanced - Process Server.

Resolving The Problem

Complete the following steps before you begin the installation:

  1. If the databases do not exist, you must create them. 

    For a DB2 database, start the DB2 Control Center. Right-click All Databases and select  Create Database > Standard.

    Note: You must complete this step for each database (Process Server, Performance Data Warehouse, and Common, if this is a Business Process Manager Advanced installation).

  2. Make sure that the page size for the database has been set to 32 KB.

    Note: The default for DB2 is 4 KB.

  3. Make sure that the user who is performing dashboard configuration has been granted DBADM authority.
    In DB2, you can grant DBADM rights in one of two ways:

    • From the command line:

      GRANT DBADM ON DATABASE TO USER <user_name>

    • By following this procedure:
      1. From the Control Center, right-click the database name.
      2. Click Authorities.
      3. Click Add User.
      4. From the Add User dialog box, select the Business Process Manager user ID that you specified (for example, db2admin), and click OK.
      5. In the User list, select the Business Process Manager user ID, change the DBADM authority to Yes, and click OK.

Related Information

[{"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Installation \/ Configuration","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"General","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSFTBX","label":"IBM Business Process Manager Express"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"General","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"7.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
15 June 2018

UID

swg21499740