Updating the IBM DB2 database

Keep your system secure and compatible by updating to the latest supported IBM DB2 version. This ensures you have the newest features, performance improvements, and security fixes.
    Important:
  • You can only use this procedure with an IBM DB2 database provided by Ricoh with RICOH ProcessDirector. If you install and manage the database separately, you must download and install updates directly from the publisher.
  • Take a snapshot or backup of the RICOH ProcessDirector system to avoid data loss.
  • Verify that antivirus or other security software that locks and scans files is still disabled on the RICOH ProcessDirector system.
To install the update package:
  1. Log in to the primary computer as root.
  2. In a command prompt, use these commands to switch to the aiw1 user, stop RICOH ProcessDirector as aiw1 user, and force stop any DB2 processes, type:
    su - aiw1 
stopaiw
db2stop force
exit
  3. Copy the ZIP file that you downloaded from the RICOH Software website to a temporary location. For example, you can use the /aiw/aiw1/tmp directory.
  4. To generate the MD5 checksum of the package, enter:
    md5sum /aiw/aiw1/tmp/<file_name>.zip

    where <file_name> is the name of the ZIP file.

    Compare the result with the value provided on the RICOH Software website. If the values do not match, download the package again.

  5. To unpack the ZIP file, type: 
    cd /aiw/aiw1/tmp
mkdir <directory_name>
mv <file_name>.zip <directory_name>/
unzip <file_name>.zip

    where <directory_name> is the name of directory you want to unpack the file and <file_name> is the name of the fix pack file.

  6. To install the update, make sure you are the root user and then type:
    cd db  
./installFixPack -b /opt/infoprint/ippd/db
      Note:
    • If the installation fails with a message about missing the mksh package or file, type:

      ./installFixPack -b /opt/infoprint/ippd/db -f sysreq

      This command lets you install the update even if the mksh package or file is missing.
  7. If you do not want to choose a different installation directory for the update, select No at the next prompt.
  8. To verify the package version after the installation completes, type: 
    su - aiw1
db2level

    Check that the output lists the updated version.

  9. To verify that the installation did not deactivate the IBM DB2 license, type:
    db2licm -l

    The output should be similar to this example:

    Product name: "DB2 Enterprise Server Edition" 
License type: "CPU Option"
Expiry date: "Permanent" 
Product identifier: "db2ese" 
… 
Enforcement policy: "Soft Stop"

Related information:

Downloading security updates
Updating the Java version for IBM DB2 database
Parent topic: Downloading and installing security updates