Running a Java migration from 5.0 to 5.5

When you migrate the IBM® Connections home page database schema from 5.0 to 5.5, you must run a Java migration.

About this task

Important: Instead of following the instructions in this topic, please follow the updated instructions in technote: http://www.ibm.com/support/docview.wss?uid=swg21991138. This technote contains a JAR file that you need to copy to the IBM Connections Wizards/lib folder.
Old status updates that are missing in Communities, Homepage, and Profiles after the migration process to 5.5 CR1 must be updated.
Note: For Linux use ':' instead of ';' as classpath separator, and run the Linux command on a single line.
Note: Verify the user grants for executing scripts.- you must be able to read the DB schema value.
Note: DB schema version must be greater or equal to 475.

Procedure

  • Update the DBWizard tools /lib directory

    The DBWizard /lib directory does note enclose the following News API: lc.shindig.serverapi.remote.jar. Also, the java migration tool command does not define it into the classpath command option

    1. Locate and copy the missing JAR lc.shindig.serverapi.remote.jar into the DBWizard tools /lib directory. You can find the missing JAR under a server profile directory, for example<websphere_installation_path>\AppServer\profiles\<appserver_name>\installedApps\<cell_name>\News.ear\lc.shindig.serverapi.remote.jar
    2. Paste lc.shindig.serverapi.remote.jar from <websphere_installation_path>\AppServer\profiles\<appserver_name>\installedApps\<cell_name>\News.ear\ into <DBWizard_uncompressd_dir>\lib.
    3. Navigate to the DBWizard decompressed directory and modify the command to include the new JAR into the classpath.
  • Use the appropriate Java command for your operating system and database type:
    1. DB2® for Linux/AIX®
      jvm/OS/jre/bin/java
      -Dfile.encoding=UTF-8
      -Xmx1024m
      -classpath
      jdbc_library_location/db2jcc4.jar:
      lib/lc.dbmigration.default.jar:
      lib/commons-logging-1.0.4.jar:
      lib/news.common.jar:
      lib/news.migrate.jar:
      lib/news.core.service.jar:
      lib/commons-lang-2.4.jar:
      lib/lc.events.internal.jar:
      lib/lc.shindig.serverapi.remote.jar
      com.ibm.lconn.news.migration.next60.NewsMigrationFrom50To60
      -dburl jdbc:db2://dbHost:dbPort/HOMEPAGE
      -dbuser dbUser
      -dbpassword dbPassword
      > java.out.log 2>&1
    2. DB2 for Windows
      jvm\win\jre\bin\java
      -Dfile.encoding=UTF-8
      -Xmx1024m
      -classpath
      jdbc_library_location\db2jcc4.jar;
      lib\lc.dbmigration.default.jar;
      lib\commons-logging-1.0.4.jar;
      lib\news.common.jar;
      lib\news.migrate.jar;
      lib\news.core.service.jar;
      lib\commons-lang-2.4.jar;
      lib\lc.events.internal.jar;
      lib\lc.shindig.serverapi.remote.jar
      com.ibm.lconn.news.migration.next60.NewsMigrationFrom50To60
      -dburl jdbc:db2://dbHost:dbPort/HOMEPAGE
      -dbuser dbUser
      -dbpassword dbPassword
      > java.out.log 2>&1
    3. Oracle for Linux
      jvm/OS/jre/bin/java
      -Dfile.encoding=UTF-8
      -Xmx1024m
      -classpath
      jdbc_library_location/ojdbc6.jar:
      lib/lc.dbmigration.default.jar:
      lib/commons-logging-1.0.4.jar:
      lib/news.common.jar:
      lib/news.migrate.jar:
      lib/news.core.service.jar:
      lib/commons-lang-2.4.jar:
      lib/lc.events.internal.jar:
      lib/lc.shindig.serverapi.remote.jar
      com.ibm.lconn.news.migration.next60.NewsMigrationFrom50To60
      -dburl jdbc:oracle:thin:@//dbHost:dbPort/dbinstance
      -dbuser dbUser
      -dbpassword dbPassword
      > java.out.log 2>&1
    4. Oracle for Windows
      jvm\win\jre\bin\java
      -Dfile.encoding=UTF-8
      -Xmx1024m
      -classpath
      jdbc_library_location\ojdbc6.jar;
      lib\lc.dbmigration.default.jar;
      lib\commons-logging-1.0.4.jar;
      lib\news.common.jar;
      lib\news.migrate.jar;
      lib\news.core.service.jar;
      lib\commons-lang-2.4.jar;
      lib\lc.events.internal.jar;
      lib\lc.shindig.serverapi.remote.jar
      com.ibm.lconn.news.migration.next60.NewsMigrationFrom50To60
      -dburl jdbc:oracle:thin:@//dbHost:dbPort/dbInstance
      -dbuser dbUser
      -dbpassword dbPassword
      > java.out.log 2>&1
      
      Where:
      • jdbc_library_location is the location of the JDBC driver
      • dbHost is the name of the system that hosts the database
      • dbPort is the communications port of the database
      • dbUser is the database administrator ID
      • dbPassword is the administrator password.
    5. SQL Server for Windows
      jvm\win\jre\bin\java
      -Dfile.encoding=UTF-8
      -Xmx1024m
      -classpath
      jdbc_library_location\sqljdbc4.jar;
      lib\lc.dbmigration.default.jar;
      lib\commons-logging-1.0.4.jar;
      lib\news.common.jar;
      lib\news.migrate.jar;
      lib\news.core.service.jar;
      lib\commons-lang-2.4.jar;
      lib\lc.events.internal.jar;
      lib\lc.shindig.serverapi.remote.jar
      com.ibm.lconn.news.migration.next60.NewsMigrationFrom50To60
      -dburl jdbc:sqlserver://dbHost:dbPort;databaseName=HOMEPAGE
      -dbuser dbUser
      -dbpassword dbPassword
      > java.out.log 2>&1
      Where:
      • jdbc_library_location is the location of the JDBC driver
      • dbHost is the name of the system that hosts the database
      • dbPort is the communications port of the database
      • dbUser is the database administrator ID
      • dbPassword is the administrator password.