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:

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:

Log in to the primary computer as root.
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
```
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.
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.
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.
To install the update, make sure you are the root user and then type:
```
cd db  
./installFixPack -b /opt/infoprint/ippd/db
```
- 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.
If you do not want to choose a different installation directory for the update, select No at the next prompt.
To verify the package version after the installation completes, type:
```
su - aiw1
db2level
```
Check that the output lists the updated version.

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"

RICOH ProcessDirector™ for Windows

Updating the IBM DB2 database

Related information: