Migrating DB2 database schemas for CR2

Run SQL scripts to update IBM® Connections 5.5 or 5.5 CR1 database schemas to CR2 in an existing IBM WebSphere® Application Server and DB2® database environment.

Before you begin

Before applying updates, back up your databases. For more information, see Backing up IBM Connections.

Make sure to configure the DB2 databases for unicode so that DB2 tools such as export and import do not corrupt unicode data. For more information see, Configuring Unicode for databases.

Ensure that you have installed and configured all supporting software for version 5.5.

About this task

This topic describes how to update IBM Connections 5.5 databases to CR2.

Notes:

After you run each command, examine the output of the command for error messages. If you find errors, resolve them before continuing with the update process.
To improve readability, some commands and file paths in this topic are displayed on separate lines. Ignore these formatting conventions when you enter the commands.

To update databases manually, complete the following steps:

Procedure

From the 5.5 package, copy the 55cr2-database-updates.zip file to a temporary directory on your database server.
Extract the SQL scripts pertinent to your version and database platform, preserving the folder structure.
Log in to the WebSphere Application Server Integrated Solutions Console on your Deployment Manager.
Go to Applications > Application types > WebSphere enterprise Applications.
Stop all IBM Connections applications.
(DB2 on Windows™ OS.) You must perform DB2 administration tasks with full administrator privileges.
1. Logged in as the instance owner, open a command prompt and change to the DB2 bin directory. For example: C:\Program Files\IBM\SQLLIB\BIN.
2. Enter the following command: db2cwadmin.bat. This command opens the DB2 command line processor while also setting your DB2 privileges.
Log in as the database administrator.
Change to the folder where the SQL scripts were extracted for your version of Connections and the database product you are using.
If you preserved the folder structure of the .zip file, the SQL scripts are organized by version number.
- Scripts for updating 5.5 databases are in the 55cr2-database-updates\From-55 folder.
Note: To capture the output of each command to a log file, append the following parameter to each command: >> /file_path/db_application.log
where file_path is the full path to the log file and application is the name of the log file. For example:
db2 -td@ createDb.sql >> /home/db2inst1/db_activities.log
Ensure that you have write permissions for the directories and log files.
Skip this step if you are updating databases from 5.5 CR1 to CR2.

If you are updating databases from 5.5, navigate to the db2 folder from the 55cr2-database-updates\From-55 folder.

Enter the following commands one at a time to update the Homepage, Activities, Files, Mobile, and Wikis databases to 5.5 CR2:


db2 -td@ -vf 55-CR1-homepage-db2.sql
db2 -td@ -vf 55-CR2-activities-db2.sql
db2 -td@ -vf 55-CR2-files-db2.sql
db2 -td@ -vf 55-CR2-homepage-db2.sql
db2 -td@ -vf 55-CR2-mobile-db2.sql
db2 -td@ -vf 55-CR2-wikis-db2.sql

Skip this step and go to What to do next if you updated your databases from 5.5 in the previous step.
If you are updating databases from 5.5 CR1, navigate to the db2 folder from the 55cr2-database-updates\From-55 CR1 folder.
Enter the following commands one at a time to update the Activities, Files, Homepage, Mobile, and Wikis databases to 5.5 CR2:
```
db2 -td@ -vf 55-CR2-activities-db2.sql
db2 -td@ -vf 55-CR2-files-db2.sql
db2 -td@ -vf 55-CR2-homepage-db2.sql
db2 -td@ -vf 55-CR2-mobile-db2.sql
db2 -td@ -vf 55-CR2-wikis-db2.sql
```

What to do next

Check that all the databases are working correctly.