Installing and configuring your own copy of DB2 on a different computer

Use your own DB2 server on a different computer and a DB2 client on the same computer as RICOH ProcessDirector if:
  • You have other applications that already use DB2 on another computer.
  • You already have a DB2 license for another computer that you want to use with RICOH ProcessDirector.
  • You want to manage DB2 outside RICOH ProcessDirector.
  • You want to use the same DB2 server with several RICOH ProcessDirector primary servers.

The DB2 client and server do not have to be on the same operating system, but they must be at the same level and fix pack. RICOH ProcessDirector only supports using DB2 11.5.8 or later in this configuration.

    Important:
  • On Linux, the DB2 server requires a 64-bit operating system.

Before you install RICOH ProcessDirector, you must install and configure a DB2 server on the other computer and a DB2 client on the primary computer. If you are installing a manual failover configuration, you must install the DB2 client on both the active and the backup computers.

To install and configure the DB2 server and client:

  1. Install DB2 11.5.8 or later using the installation instructions provided with DB2.
    In the Set up a DB2 instance window, choose the option to defer this task until later.
  2. Verify that the computer that the DB2 server is installed on meets the memory and disk requirements to support RICOH ProcessDirector, keeping these issues in mind:
    • Each RICOH ProcessDirector primary server that connects to this DB2 server must use a separate directory on the DB2 server to store its databases. Each of those directories must have 22 GB of space available. By default, the primary servers use the home directory for their instance user to store their databases. If you use the default setting, make sure that the home directory for the instance user is large enough.

      However, in a manual failover configuration, the active and the backup computers share a DB2 instance. As a result, they both use the same directory and only require 22 GB of space, not 44 GB.

    • If you change the directory that the instance uses to store its databases, make sure that the home directory for each instance user has at least 300 MB of space available.
  3. Use the provided script to configure DB2 to work with each RICOH ProcessDirector primary server that connects to it.
    This configuration includes: creating a DB2 instance for RICOH ProcessDirector to communicate with; tuning the instance; creating the required groups and users (if needed); and starting the instance.

    The script is included in the /scripts directory on the RICOH ProcessDirector base product DVD.

    To configure the DB2 server:

    1. Insert the base product DVD in the drive and go to the /scripts directory.
        Note:
      • If you are using a Red Hat or Rocky Linux system, the drive might mount automatically. However, drives that are mounted automatically on those systems are set up so that you cannot run programs from the media. You must unmount the drive and mount it again with the exec option before you can continue. You can use this command:

        mount -t iso9660 -o remount, exec <mount_point>

        You must remount the drive for every CD or DVD that you insert.

    2. Type this command to run the script and press Enter:
      ./setupRemoteDB2.sh
    3. Respond to the prompts as required:
      • When the script asks for the DB2 instance name, type an instance name to use with one of your primary servers.

        Each primary server must have a unique DB2 instance. The default instance name is aiwinst; you can use this name with one of your primary servers. Record the instance name and password to use when you install RICOH ProcessDirector.

      • When the script asks for the DB2 instance group and the DB2 fenced user group, you can choose the default group or another existing group, or specify a new group to be created. The defaults are:
        DB2 instance group
        aiwdbgrp
        DB2 fenced group
        aiwdbfgp
        The instance user uses the DB2 instance group as its primary group; the DB2 fenced user uses the DB2 fenced user group as its primary group. If you are unsure which group to use, consult your DB2 administrator.
      • When the script asks for the DB2 fenced user name, you can choose the default user or another existing user, or specify a new user to be created. The default is aiwdbfid. If you are unsure which user to use, consult your DB2 administrator. You should never log in as this user, but you might need to recognize it for recordkeeping and security.
      • When the script asks for a DB2 instance port number, enter the port that you want DB2 to listen on for the primary server that uses this instance. The port number must be less than 65536. Record the port number to use when you install RICOH ProcessDirector.
    4. On the DB2 server computer, run the script again for each primary server that will connect to DB2.
        Note:
      • If you are configuring a manual failover environment, the backup computer shares the DB2 instance with the active computer. Do not run the script again for a backup computer.
    5. Record the host name or IP address of the computer that DB2 is installed on.
  4. Install the DB2 client on each of the computers that you plan to install RICOH ProcessDirector on, including any backup computers.
    Use the DB2 installation CD and choose the IBM Data Server Runtime Client.

    In the Set up a DB2 instance window of the installer, choose the option to defer this task until later.

    After the installation finishes, make sure the same DB2 Fix Pack that is installed on the client is also installed on the server.

  5. Continue installing RICOH ProcessDirector using the instructions in Installing.
Parent topic: Installing DB2