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.

About this task

Use the appropriate Java migration command for your database type.

Procedure

To run the Java migration for DB2:

From a command prompt, change to the Wizards directory.
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/commons-logging-1.0.4.jar:
lib/news.common.jar:
lib/news.migrate.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\commons-logging-1.0.4.jar;
lib\news.common.jar;
lib\news.migrate.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.

To run the Java migration for Oracle:

From a command prompt, change to the Wizards directory.
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/commons-logging-1.0.4.jar:
lib/news.common.jar:
lib/news.migrate.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\commons-logging-1.0.4.jar;
lib\news.common.jar;
lib\news.migrate.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.

To run the Java migration for SQL Server

Note: You must use the IBM JDK that comes with the database wizard package. Also, note that GNU java is not supported.
1. From a command prompt, change to the Wizards directory.
2. Enter the following text as a command on a single line:
  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;  
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.