在 Windows 上升级更早的配置文件

如果从早于 5.5 的 HCL Connections 发行版升级,请在 Microsoft Windows 上的 Connections 5.5 中完成以下过程以升级更早的配置文件,以便这些配置文件可以在 HCL Verse 中正常使用。

过程

  1. 将以下行复制到文本编辑器中,并将其保存为 Connections\xkit\connections.sql\profiles 目录中的 fixhashphoto.cmd。 
    注: 此步骤中显示的一些文本分到多行中,以便内容匹配文档页面;其他行已缩进。在实际文件中,该文本位于一行中。
    @echo off
    setlocal ENABLEEXTENSIONS
    rem # ***************************************************************** 
    rem #                                                                   
    rem # Licensed Materials - Property of IBM                              
    rem #                                                                   
    rem # 5724-S31                                                          
    rem #                                                                   
    rem # Copyright IBM Corp. 2014, 2016  All Rights Reserved.              
    rem #                                                                   
    rem # US Government Users Restricted Rights - Use, duplication or       
    rem # disclosure restricted by GSA ADP Schedule Contract with           
    rem # IBM Corp.                                                         
    rem #                                                                   
    rem # ***************************************************************** 
    
    set FIXUP_DIR=%~dp0
    set MIGRATION_DIR=%FIXUP_DIR%
    set MIGRATION_DIR=%FIXUP_DIR%migrate.lib
    set DB2_USER=LCUSER
    set DB2_PASSWORD=<DB2PASSWORD>
    set DB2_HOST=<DB2HOSTNAME>
    set DB2_PORT=50000
    set JAVA_HOME=c:\IBM\WebSphere\AppServer\java
    set DB2_JAVA_HOME=C:\IBM\SQLLIB\java
    set DB2_DB_NAME=PEOPLEDB
    
    if not exist %MIGRATION_DIR% echo WARNING: Directory MIGRATION_DIR %MIGRATION_DIR% does not exist!
    if not defined DB2_JAVA_HOME echo WARNING: Env variable DB2_JAVA_HOME is not set!
    if not defined DB2_HOST echo WARNING: Env variable DB2_HOST is not set!
    if not defined DB2_PORT echo WARNING: Env variable DB2_PORT is not set!
    if not defined DB2_DB_NAME echo WARNING: Env variable DB2_DB_NAME is not set!
    if not defined DB2_USER echo WARNING: Env variable DB2_USER is not set!
    if not defined DB2_PASSWORD echo WARNING: Env variable DB2_PASSWORD is not set!
    
    echo FIXUP_DIR=%FIXUP_DIR%
    echo MIGRATION_DIR=%MIGRATION_DIR%
    echo DB2_JAVA_HOME=%DB2_JAVA_HOME%
    echo DB2_HOST:DB2_PORT=%DB2_HOST%:%DB2_PORT%
    echo DB2_DB_NAME:DB2_USER=%DB2_DB_NAME%:%DB2_USER%
    
    echo %DB2_JAVA_HOME%/jdk/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_JAVA_HOME%/jdk/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%"
    
  2. 编辑 fixhashphoto.cmd。用适当的值替换 <DB2PASSWORD><DB2HOSTNAME>
  3. 在 Windows 命令提示符处运行修复脚本:
    fixhashphotos.cmd
    输出示例:
    MigrateHashEmail : Processed 100 entries in this batch.  Total updates 139200.