Tag: windows

Store IBM Connections data on Unix filesystem

The last days I tried to move the IBM Connections datastore (or “shared data” folder) from a single-node Linux system to a Microsoft Windows file server.

The Connections data files are stored in a bunch of folders and sub-folders, managed by the associated applications. Linux filesystems like EXT3 support case-sensitive names. Connections Blogs and other applications create folders with case-sensitive names on this filesystem type to structure the data.

NTFS filesystem which is used on Windows file server does not support case-sensitive file and folder names. As a result it’s not possible to copy Connections data from Linux to Windows filesystem.

This might be annoying in some situations, especially because some of the applications are managing data without braking cross-platform compatibility. The Connections Files application for example stores it’s data in folders with numerical names.

 

IBM DB2 cross-patform migration

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)