+

Search Tips   |   Advanced Search

Run a Java migration from 4.0 to 4.5


Overview

When migrating the Connections Homepage database schema from 4.0 to 4.5, also run a java migration.


For DB2

  1. cd Wizards

  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 path/to/db2jcc.jar:path/to/db2jcc_license_cu.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.next45.NewsMigrationFrom40To45
    -dburl jdbc:db2://dbHost:dbPort/HOMEPAGE \
    -dbuser dbUser \
    -dbpassword dbPassword > java.out.log 2>&1

  3. Run:

      db2 -tvf post-java-migration-40-45.sql


For Oracle

  1. cd Wizards

  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 lib/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.next45.NewsMigrationFrom40To45 \
     -dburl jdbc:oracle:thin:@<dbHost>:<dbPort>:<dbInstance> \
     -dbuser dbUser  \
     -dbpassword dbPassword > java.out.log 2>&1

    where:

  3. Run:

      @post-java-migration-40-45.sql


For SQL Server

To run a java migration:

  1. cd Wizards

  2. Enter the following text as a command on a single line:

      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.next45.NewsMigrationFrom40To45 -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 hosting the database.
    • dbPort is the communications port of the database.
    • dbUser is the database administrator ID.
    • dbPassword is the administrator password.

  3. Run:

      -i post-java-migration-40-45.sql


Parent topic:
Update 4.0 and 4.5 databases manually

Use the appropriate java migration script for the database type: