Running a Java migration from 4.5 to 5.0

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

For DB2®

About this task

To run the Java migration:
  1. From a command prompt, change to the Wizards directory.
  2. Enter the following text as a command on a single line:
    For AIX® or Linux:
    jvm/OS/jre/bin/java 
-Dfile.encoding=UTF-8 
-Xmx1024m 
-classpath
jdbc_library_location/db2jcc4.jar:
lib/lc.dbmigration.default.jar:
lib/lc.events.internal.jar:
lib/commons-logging-1.0.4.jar:
lib/commons-lang-2.4.jar:
lib/news.common.jar:
lib/news.migrate.jar: 
lib/news.core.service.jar
com.ibm.lconn.news.migration.next50.NewsMigrationFrom45To50
-dburl jdbc:db2://dbHost:dbPort/HOMEPAGE
-dbuser dbUser 
-dbpassword dbPassword
> java.out.log 2>&1
    where:
    • jdbc_library_location is the location of your JDBC driver.
    • dbHost is the name of the system that hosts your database.
    • dbPort is the communications port of the database.
    • dbUser is the database administrator ID.
    • dbPassword is the administrator password.
    For Windows:
    jvm\win\jre\bin\java 
-Dfile.encoding=UTF-8 
-Xmx1024m 
-classpath
jdbc_library_location\db2jcc4.jar;
lib\lc.dbmigration.default.jar;
lib\lc.events.internal.jar;
lib\commons-logging-1.0.4.jar;
lib\commons-lang-2.4.jar;
lib\news.common.jar;
lib\news.migrate.jar; 
lib\news.core.service.jar
com.ibm.lconn.news.migration.next50.NewsMigrationFrom45To50
-dburl jdbc:db2://dbHost:dbPort/HOMEPAGE
-dbuser dbUser 
-dbpassword dbPassword
> java.out.log 2>&1
    where:
    • jdbc_library_location is the location of your JDBC driver.
    • dbHost is the name of the system that hosts your database.
    • dbPort is the communications port of the database.
    • dbUser is the database administrator ID.
    • dbPassword is the administrator password.

For Oracle

About this task

To run the Java migration:
  1. From a command prompt, change to the Wizards directory.
  2. Enter the following text as a command on a single line:
    For AIX or Linux:
    java 
-Dfile.encoding=UTF-8 
-Xmx1024m 
-classpath 
jdbc_library_location/ojdbc6.jar:
lib/lc.dbmigration.default.jar:
lib/lc.events.internal.jar:
lib/commons-logging-1.0.4.jar:
lib/commons-lang-2.4.jar:
lib/news.common.jar:
lib/news.migrate.jar: 
lib/news.core.service.jar 
com.ibm.lconn.news.migration.next50.NewsMigrationFrom45To50 
-dburl jdbc:oracle:thin:@//dbHost:dbPort/dbinstance
-dbuser dbUser 
-dbpassword dbPassword 
> java.out.log 2>&1
    where:
    • jdbc_library_location is the location of your JDBC driver.
    • dbHost is the name of the system that hosts your database.
    • dbPort is the communications port of the database.
    • dbinstance is the database instance.
    • dbUser is the database administrator ID.
    • dbPassword is the administrator password.
    For Windows:
    jvm\win\jre\bin\java 
-Dfile.encoding=UTF-8 
-Xmx1024m 
-classpath
jdbc_library_location\ojdbc6.jar;
lib\lc.dbmigration.default.jar;
lib\lc.events.internal.jar;
lib\commons-logging-1.0.4.jar;
lib\commons-lang-2.4.jar;
lib\news.common.jar;
lib\news.migrate.jar;
lib\news.core.service.jar
com.ibm.lconn.news.migration.next50.NewsMigrationFrom45To50
-dburl jdbc:oracle:thin:@//dbHost:dbPort/dbInstance
-dbuser dbUser 
-dbpassword dbPassword
> java.out.log 2>&1
    where:
    • jdbc_library_location is the location of your JDBC driver.
    • dbHost is the name of the system that hosts your database.
    • dbPort is the communications port of the database.
    • dbinstance is the database instance.
    • dbUser is the database administrator ID.
    • dbPassword is the administrator password.

For SQL Server

About this task

Note: You must use the IBM JDK that comes with the database wizard package. Also, note that GNU java is not supported.
To run the Java migration:
  1. From a command prompt, change to the Wizards directory.
  2. Enter the following text as a command on a single line:
    For AIX or Linux:
    java 
-Dfile.encoding=UTF-8 
-Xmx1024m 
-classpath
jdbc_library_location\sqljdbc4.jar:
lib/lc.dbmigration.default.jar:
lib/lc.events.internal.jar:
lib/commons-logging-1.0.4.jar:
lib/commons-lang-2.4.jar:
lib/news.common.jar:
lib/news.migrate.jar: 
lib/news.core.service.jar
com.ibm.lconn.news.migration.next50.NewsMigrationFrom45To50
-dburl jdbc:sqlserver://dbHost:dbPort;databaseName=HOMEPAGE
-dbuser dbUser 
-dbpassword dbPassword
> java.out.log 2>&1
    where:
    • jdbc_library_location is the location of your JDBC driver.
    • dbHost is the name of the system that host your database.
    • dbPort is the communications port of the database.
    • dbUser is the database administrator ID.
    • dbPassword is the administrator password.
    For Windows:
    jvm\win\jre\bin\java 
-Dfile.encoding=UTF-8 
-Xmx1024m 
-classpath
jdbc_library_location\sqljdbc4.jar;
lib\lc.dbmigration.default.jar;
lib\lc.events.internal.jar;
lib\commons-logging-1.0.4.jar;
lib\commons-lang-2.4.jar;
lib\news.common.jar;
lib\news.migrate.jar; 
lib\news.core.service.jar 
com.ibm.lconn.news.migration.next50.NewsMigrationFrom45To50
-dburl jdbc:sqlserver://dbHost:dbPort;databaseName=HOMEPAGE
-dbuser dbUser 
-dbpassword dbPassword
> java.out.log 2>&1
    where:
    • jdbc_library_location is the location of your JDBC driver.
    • dbHost is the name of the system that hosts your database.
    • dbPort is the communications port of the database.
    • dbUser is the database administrator ID.
    • dbPassword is the administrator password.