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
-
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
-
Paste lc.shindig.serverapi.remote.jar from
<websphere_installation_path>\AppServer\profiles\<appserver_name>\installedApps\<cell_name>\News.ear\
into <DBWizard_uncompressd_dir>\lib.
-
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:
-
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
-
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
-
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
-
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.
-
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.