Upgrading older profiles on Linux

If you upgrade from an IBM Connections release that is earlier than 5.5, on Linux, complete this procedure in Connections 5.5 to upgrade older profiles so that they work in IBM Verse.

Procedure

Extract Connections_5.5_Wizards_lin_aix.tar:


cd /opt/
cp /tmp/Connections_5.5_Wizards_lin_aix.tar
tar -xvf Connections_5.5_Wizards_lin_aix.tar

Change the directory:


cd /opt/Wizards/connections.sql/profiles/db2/fixup/

Copy the file fixup50j.sh:
```
cp fixup50j.sh fixhashphoto.sh
```
Allow permission:
```
chmod a+x fixhashphoto.sh
```

Edit fixhashphoto.sh. Replace <PASSWORD> and <peopledb_hostname> with appropriate values.

Note: Some text shown in this step is broken into multiple lines so that the content fits on the documentation page; the additional lines are indented. In the actual file, this text is on one line.

#!/bin/bash

DB2_PASSWORD=<PASSWORD>
DB2_USER=LCUSER
JAVA_HOME=/opt/IBM/WebSphere/AppServer/java
DB2_JAVA_HOME=/opt/ibm/db2/V10.5/java
DB2_HOST=<peopledb_hostname>
DB2_PORT=50000
DB2_DB_NAME=PEOPLEDB

FIXUP_DIR=`dirname $0`
MIGRATION_DIR=`dirname ${FIXUP_DIR}`
MIGRATION_DIR=`dirname ${MIGRATION_DIR}`/migrate.lib

echo $JAVA_HOME/bin/java -Dfile.encoding=UTF-8 -Xmx1024m -classpath \
${DB2_JAVA_HOME}/db2jcc.jar:${DB2_JAVA_HOME}/db2jcc_license_cu.jar:
   ${MIGRATION_DIR}/profiles.migrate.jar:
   ${MIGRATION_DIR}/commons-logging-1.0.4.jar:
   ${MIGRATION_DIR}/lc.util.web-30.jar:
   ${MIGRATION_DIR}/commons-lang-2.4.jar:
   ${MIGRATION_DIR}/commons-codec-1.3-minus-mp.jar \
com.ibm.profiles.migrate.MigrateHashEmail \
jdbc:db2://${DB2_HOST}:${DB2_PORT}/${DB2_DB_NAME} \
"${DB2_USER}" "******"

$JAVA_HOME/bin/java -Dfile.encoding=UTF-8 -Xmx1024m -classpath \
${DB2_JAVA_HOME}/db2jcc.jar:${DB2_JAVA_HOME}/db2jcc_license_cu.jar:
   ${MIGRATION_DIR}/profiles.migrate.jar:
   ${MIGRATION_DIR}/commons-logging-1.0.4.jar:
   ${MIGRATION_DIR}/lc.util.web-30.jar:
   ${MIGRATION_DIR}/commons-lang-2.4.jar:
   ${MIGRATION_DIR}/commons-codec-1.3-minus-mp.jar \
com.ibm.profiles.migrate.MigrateHashEmail \
jdbc:db2://${DB2_HOST}:${DB2_PORT}/${DB2_DB_NAME} \
"${DB2_USER}" "${DB2_PASSWORD}"

Run the fixup script:


cd /opt/Wizards/connections.sql/profiles
./db2/fixup/fixhashphoto.sh

Example output:


MigrateHashEmail : Processed 100 entries in this batch. 
Total updates 139200.

To check that a profile was updated:


select PROF_IDHASH from EMPINST.EMPLOYEE where prof_uid='<UID_FROM_USER>'