Validating the post-upgrade DBA step (Db2)

Applies to:

Run the script to validate the post-upgrade DBA steps.

Before you begin

The IBM® Db2® database server is running. All other OpenPages® servers are stopped.
The JAVA_HOME system variable is defined and points to the Java™ SDK that is installed with Db2. For example, for Db2 11.5:
```
export JAVA_HOME=/db2/V11.5/java/jdk64
export PATH=$JAVA_HOME/bin:$PATH
```
If you are running the script from another host, ensure that JAVA_HOME is pointing to the Java SDK that is installed on the computer.
The DB2_HOME system variable is defined.

Log on to the Db2 database server computer as the OpenPages application user, opuser.
Go to the /OP_<version>_Main/OP_<version>_Configuration/Database/DB2/UPGRADE_SCRIPTS directory.
Verify that you have execute permission on the scripts in UPGRADE_SCRIPTS and its subdirectories.
Open the sql-wrapper.sql file. Verify that the values are suitable for your environment.
Run the following command:
- On Linux®:
```
./op-database-product-upgrade.sh postdba '<op_password>'
```
- Windows:
```
op-database-product-upgrade.bat postdba "<op_password>"
```
Note: Quotation marks are required around a password only if the password contains special characters. See Special characters in passwords.
Verify that the script completed successfully.
Look for the following message: Status:Success or a return code of 0.
You can also check the log file, op-database-product-upgrade.postdba.*.log.
Remove the passwords from the sql-wrapper.sql file for security purposes.

The OpenPages database is upgraded.