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™:
where: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
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™:
where: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
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:
where: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
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:
where: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
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.
- From a command prompt, change to the Wizards directory.
-
Enter the following text as a command on a single line:
For Windows:
where: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
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.