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

Before you install RICOH ProcessDirector, you must install and configure a DB2 server on the database server and a DB2 client on each primary server.

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.
  • Rocky Linux 9.0 through latest 9.X and Rocky Linux 10.0 through latest 10.X do not support the IBM DB2 database.

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:
    • 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 or mount the ISO file and go to the /scripts directory.
        Note:
      • If you are using Red Hat version 9.x or 10.x versions, 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 then script asks for the DB2 instance name, type an instance name for the system.
      • 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. Record the host name or IP address of the computer that DB2 is installed on.
  4. Install the DB2 client on both primary servers.
    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.

Parent topic: Installing DB2