Upgrading Db2 (Windows)

You must upgrade to a supported version of IBM® Db2® before you migrate or upgrade to IBM OpenPages® with Watson™ 8.2.

This task provides the basic steps for upgrading IBM Db2. For more information about this process, see the IBM Db2 documentation.

About this task

Important: Fix pack 8.2.0.1 supports Db2 11.5.4. If you are migrating or upgrading to 8.2, complete the migration or upgrade before you apply the Db2 11.5.4 fix pack. Otherwise, you will see errors during the OpenPages database upgrade.

This task uses the following conventions:

db2admin: The OpenPages database instance owner
openpage: The OpenPages database user
opx: The name of the OpenPages database
db2inst2: The Cognos® database instance owner
cognosdb: The name of the Cognos content store
<db_server>: The hostname of the Db2 database server

The steps that you need to do depend on whether you are using your existing database server for OpenPages or using a new database server. If you are using a new database server, you skip the steps about upgrading the database instances and upgrading the databases. Later in the OpenPages migration process, you restore the databases and then upgrade them to the new Db2 version.

Note: When you run Db2 utilities, such as

db2
connect

or db2rbind, do not use quotation marks around passwords.

Procedure

Stop the following servers:
- Stop all OpenPages application servers.
- Stop the global search services.
- Stop all IBM Cognos services.
Check that your system meets the installation prerequisites.
For more information, see db2prereqcheck - Check installation prerequisites.
1. Go to the directory where you extracted the Db2 installation package.
2. As the root or sudo user, check the installation requirements.
```
db2prereqcheck –i -v <version>
```
  Where <version> is the Db2 version that you want to install.
  For example:
```
db2prereqcheck –i -v 11.5.0.0
```
  If successful, you see the message DBT3533I The db2prereqcheck utility has confirmed that all installation prerequisites were met.
3. Review the log file.
4. As the OpenPages instance owner (for example, db2admin), run the pre-upgrade checks:
```
db2ckupgrade OPX -l c:\tmp\db2ckupgrade.log -u db2admin -p password
```
Complete the Db2 pre-upgrade tasks for both the OpenPages database and the Cognos content store. For more information, see Pre-upgrade tasks for DB2® servers.

If you get warnings about the discontinued SYSFUN.ASCII1 function, you can ignore them.
Check the value of the application heap size for the Cognos database.
1. Open the Db2 command line processor (CLP).
2. Run the following command as the database instance owner. Replace <cognosdb> with the name of your Cognos database.
```
db2 get db cfg for <cognosdb> | findstr APPLHEAPSZ
```
3. If the value is less than 4096, increase it to a minimum of 4096.
  Run the following command as the database instance owner. Replace <cognosdb> with the name of your Cognos database.
```
db2 update db cfg for <cognosdb> using applheapsz 4096
```
Drop the Db2 Text Search index and disable Db2 Text Search.
For more information, see Dropping the Db2 Text Search index and disabling Db2 Text Search.
Back up the OpenPages database and the Cognos content store.
Run the IBM Db2 installation program.
The installation program installs Db2 and upgrades the existing database instances. For more information, see Upgrading a Db2 server (Windows).
1. Click Install a Product.
2. Click Work with Existing.
3. Select the installation that you use for OpenPages.
4. Select the Custom option.
5. Expand Server Support and select Db2 Text Search for installation.
6. If you do not use Tivoli® SA MP, clear the Tivoli SA MP check box.
7. Accept the default settings on each page of the wizard until you are prompted for the db2admin credentials.
8. Enter the domain and password for the db2admin user.
9. Accept the default settings on the remaining pages of the wizard. Click Finish.
When the installation process completes, check the log files.
Upgrade your OpenPages database.
For more information, see Upgrading databases.
For example, start the Db2 command line processor (CLP) and run the following commands:
```
set db2instance=db2inst1 
db2start 
db2 upgrade database opx user db2admin using password
```
Upgrade your Cognos content store database.
For more information, see Upgrading databases.
For example, start the Db2 command line processor (CLP) and run the following commands:
```
set db2instance=db2inst2 
db2start 
db2 upgrade database cognosdb user db2admin using password
```
Revalidate objects, rebind packages, and redeploy the Java™ routines for OpenPages in the OpenPages database.
1. Start the Db2 command line processor (CLP).
2. Run the following command:
```
set db2instance=db2inst1
```
3. Copy the /OP_<version>_Main/OP_<version>_Configuration/Database/DB2/INSTALL_SCRIPTS directory to the database server.
4. Go to the directory where you copied the INSTALL_SCRIPTS directory, and then revalidate the database objects.
  If you are upgrading to 11.5
  Run the following commands:
  db2 connect to OPX user openpage using password db2 -td@ -f pks_OP_CURRENCY_MGR.sql db2 -td@ -f pkb_OP_CURRENCY_MGR.sql clpplus -nw openpage/password@<db_server>:50000/opx @sql-wrapper revalidate.sql revalidate.log openpage
  If you are upgrading to 11.1.4.4
  Run the following command:
  clpplus -nw openpage/password@OP:50000/opx @sql-wrapper revalidate.sql revalidate.log openpage
5. Rebind the packages.
  For example:
```
db2rbind opx -l opbind.log all -u db2admin -p password -r any
```
6. Redeploy the Java routines for OpenPages.
  For example:
```
manageOPJavaRoutines.bat opx opuser "password" remove opdb2udf.jar
```
```
manageOPJavaRoutines.bat opx opuser "password" install opdb2udf.jar
```
Revalidate objects and rebind packages in the Cognos content store.

Note: When you run Db2 commands, such as db2 connect or db2rbind, do not use quotation marks around passwords.
1. Start the Db2 command line processor (CLP).
2. Run the following command:
```
set db2instance=db2inst2
```
3. Revalidate the database objects.
  For example:
```
db2 connect to cognosdb user db2admin using password
db2 "call sysproc.admin_revalidate_db_objects()"
```
4. Rebind packages in the Cognos database.
  For example:
```
db2rbind cognosdb -l cogbind.log -u db2admin -p password
```
Optional: Back up the databases.
Apply the IBM Db2 license.
1. Extract the quick start activation file for IBM Db2.
2. Start the Db2 command line processor (CLP).
3. Go to the directory where the license file, db2ese_u.lic, is stored.
4. Run the following command:
```
db2licm –a db2ese_u.lic
```
Start all IBM OpenPages with Watson services.
Configure and enable Db2 Text Search, create the index, and schedule a job to synchronize the index.
For more information, see Utilities for filtering on long string field content in a Db2 database in the IBM OpenPages with Watson Administrator's Guide.