Upgrading the DB2 database

When you upgrade RICOH ProcessDirector, the version of DB2 database that is embedded in RICOH ProcessDirector is left at the same level. You can upgrade the DB2 database before you start the RICOH ProcessDirector install program or after the install program completes.

If all these statements are true, you can upgrade the DB2 database using the DB2 installation DVD or ISO file provided with RICOH ProcessDirector:

  • Your current DB2 database and RICOH ProcessDirector system is backed up.
  • The current installed version of the DB2 database is 10.1 or 10.5.
  • You have the DB2 installation DVD or ISO file provided by Ricoh.

You can use scripts provided on the DB2 installation media to upgrade the DB2 database before or after you install RICOH ProcessDirector.

If you manually upgrade the DB2 database before upgrading RICOH ProcessDirector, do not start RICOH ProcessDirector until you upgrade to the new version. Some older versions of RICOH ProcessDirector do not work with newer versions of the DB2 database.

Whether you are installing using a DVD or an ISO image, make sure that you can access the DB2 installation media from the primary server. Complete these procedures as needed:

To upgrade the DB2 database manually:

  1. Verify that your system meets the requirements listed above.
  2. Log in to the primary computer as the system administrator that installed RICOH ProcessDirector.
      Important:
    • Make sure the password for the administrator does not include the characters " or % or ^ or passwords that contain two $. If the current password includes those characters, change the password before continuing.
    • If you change the administrator password, you must also update the passwords for the following services:
      • DB2 - DB2COPY1 - AIWINST-0
      • DB2 Remote Command Server
      • DB2DAS - DB2DAS00
      • DB2 Governor
  3. Start a command prompt as an administrator. Even if you are logged on to your system as an administrator, you must start the command prompt by selecting Run as administrator from the right-click menu.
  4. Go to the directory where the DB2 installation media is located and type scripts/upgradeDB2.bat and press Enter to run the script.
  5. Type the password for the system administrator and press Enter.
      Note:
    • It can take several minutes for the script to complete.

      When the script finishes, the command prompt returns: Successfully upgraded DB2.

  6. Verify the DB2 database level on the system. In the command prompt, type db2level and press Enter.

    The command displays the current DB2 database level along with the install path and install date. If the installation was successful, the DB2 database level is 11.5.8.

  7. Check the installation log for any errors. Go to C:\ and open upgradeDB2.log.
  8. If you upgraded the DB2 database before upgrading RICOH ProcessDirector, continue with installing RICOH ProcessDirector.
  9. If you upgraded the DB2 database after upgrading RICOH ProcessDirector, start RICOH ProcessDirector and log in to verify that the upgrade was successful.
Parent topic: Upgrading