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

  1. 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
  2. Change the directory: 
    
cd /opt/Wizards/connections.sql/profiles/db2/fixup/
  3. Copy the file fixup50j.sh: 
    cp fixup50j.sh fixhashphoto.sh
  4. Allow permission: 
    chmod a+x fixhashphoto.sh
  5. Edit fixhashphoto.sh. Replace <PASSWORD> and <peopledb_hostname> with appropriate values. 
    #!/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}"
  6. 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.
  7. To check that a profile was updated: 
    
select PROF_IDHASH from EMPINST.EMPLOYEE where prof_uid='<UID_FROM_USER>'