If your IBM Connections platform needs to move to a different operating-system (e.g. Windows to Linux) there is an important limitation for the transfer of DB2 data. A simple database backup and restore can not be used when switching the operating system.
For IBM Docs, the Forms Experience Builder (Surveys) or other 3rd-party applications this gets important for the migration from Connections 5.0 to the latest 5.5 release because Surveys and Docs are used in many customer deployments.
The DB2 database transfer for the connections core applications (homepage, files, …) with the DBT tool is working fine and is documented in the official wiki.
To move your Docs and FEB database we need another strategy:
Prepare transfer for DB2 data:
- Create database on the destination server
- Use the same SQL scripts the source database was created with
- Example: If you migrate from Docs 1.0.7 to 2.0 you have to use the SQL scripts from the 1.0.7 packages
- Update database on destination server to schema version of the source database
- Grant access (run appGrants.sql for example)
Copy DB2 data:
Use db2move to export/import all data from a database. Execute the commands with the database instance owner (db2admin, db2inst1) on the source and destination server.
- Run data export on source DB2 server for each database
- Open command window and change to a temporary folder
- db2move CONCORD export -u <db2admin_user> -p <db2admin_user_password>
- <db2admin_user>: User the source database was created with
- Import data on DB2 destination server
- Copy the temporary folder with the exported data from the source server to the destination server
- Open command window on DB2 destination server and change to the temporary folder
- db2move CONCORD load
Update DB2 database:
- Update database on the destination server with the SQL scripts from the recent release.
- Example: If you migrate from Docs 1.0.7 to 2.0 you have to use the SQL scripts from the 2.0 packages to update the database
- Grant access (run appGrants.sql for example)