Home
Updating databases manually
Manually update Lotus Connections 2.0.1 databases to release 2.5 in an existing WebSphere Application Server and database environment.
Before applying updates, back up your databases. For more information, see the Backing up Lotus Connections topic.
This topic describes how to manually update Lotus Connections release 2.0.1 databases to release 2.5. Use this procedure as an alternative to using the database wizard to update your databases.Notes
- Ensure that the forum content store is accessible from the database server before starting this task.
- To improve readability, some commands and file paths on this page are displayed on separate lines. Ignore these formatting conventions when entering the commands.
To update databases manually...
- Log in to the WAS admin console.
- Go to Applications > Enterprise Applications.
- Stop all Lotus Connections features.
- To update the databases, run the commands for your database type:
Notes
- Use the Java™ Virtual Machine (JVM) under the Wizards in the installation media. If you want to use your own JVM, ensure that the build date of the JVM is later than 20070831.
- The variables <dbHost>, <dbPort>, <dbAdmin>, and <dbPassword> represent the host name of your database server, the database server port, the database administrator ID, and the database administrator's password, respectively.
- Line breaks are added to some commands to improve readability.
- After running each command, examine the command's output for error messages. If you find errors, resolve them before continuing with the update process.
- DB2
- Log in as the database administrator.
- For each feature, change to the where the SQL scripts are stored and then enter the commands for that feature:
- Activities: Wizards/connections.sql/activities/db2
- Blogs: Wizards/connections.sql/ blogs/db2
db2 -tvf upgrade25.sql
- cd Wizards and enter the following commands:
- AIX or Linux
java -classpath
<jdbc_lib_location>/db2jcc.jar:
<jdbc_lib_location>/db2jcc_license_cu.jar:
lib/blogs.migration.jar:
lib/commons-lang-2.0.jar
org.apache.roller.
migrate.MigrateBlogsTo_2_5
db2 BLOGS
<dbHost> <dbPort>
<dbAdmin> <dbPassword>
- Windows
java -classpath
<jdbc_lib_location>\db2jcc.jar;
<jdbc_lib_location>\db2jcc_license_cu.jar;
lib\blogs.migration.jar;
lib\commons-lang-2.0.jar
org.apache.roller.
migrate.MigrateBlogsTo_2_5
db2 BLOGS
<dbHost> <dbPort>
<dbAdmin> <dbPassword>
db2 -tvf appGrants.sql
- (For DB2 9.1 users only)
db2 -tvf db291settings.sql
- Communities: Wizards/connections.sql/ communities/db2
db2 -tvf upgrade25.sql
db2 -tvf upgrade25_forum.sql
db2 -tvf uninteg_forum.sql
- cd Wizards and enter the following commands:
- AIX or Linux:
java -classpath
<jdbc_lib_location>/db2jcc.jar:
<jdbc_lib_location>/db2jcc_license_cu.jar:
lib/forum.migrate.jar:
lib/commons-lang-2.0.jar
com.ibm.lconn.forum.migrate.
Migrate201To25
db2 <dbHost> <dbPort>
SNCOMM <dbAdmin> <dbPassword>
- Windows:
java -classpath
<jdbc_lib_location>\db2jcc.jar;
<jdbc_lib_location>\db2jcc_license_cu.jar;
lib/forum.migrate.jar;
lib/commons-lang-2.0.jar
com.ibm.lconn.forum.migrate.
Migrate201To25
db2 <dbHost> <dbPort>
SNCOMM <dbAdmin> <dbPassword>
db2 -tvf integ_forum.sql
db2 -tvf integOff.sql
- cd Wizards and enter the following commands:
- AIX or Linux:
java -classpath
<jdbc_lib_location>/db2jcc.jar:
<jdbc_lib_location>/db2jcc_license_cu.jar:
lib/sncomm.migrate.jar:
lib/commons-lang-2.0.jar
com.ibm.tango.migrate.
MigrateCommunitiesTo_2_5
db2 SNCOMM <dbHost> <dbPort>
<dbAdmin> <dbPassword>
- Windows:
java -classpath
<jdbc_lib_location>\db2jcc.jar;
<jdbc_lib_location>\db2jcc_license_cu.jar;
lib\sncomm.migrate.jar;
lib\commons-lang-2.0.jar
com.ibm.tango.migrate.
MigrateCommunitiesTo_2_5
db2 SNCOMM <dbHost> <dbPort>
<dbAdmin> <dbPassword>
db2 -td@ -vf integOn.sql
- Ensure that the forum content store is accessible: from a command prompt, change to the Wizards and enter the following commands:
- AIX or Linux:
java -classpath
<jdbc_lib_location>/db2jcc.jar:
<jdbc_lib_location>/db2jcc_license_cu.jar:
lib/forum.migrate.jar:
lib/commons-lang-2.0.jar
com.ibm.lconn.forum.
migrate.DescMigrate201To25
db2 <path_to_forumContentStore>
<dbHost> <dbPort>
SNCOMM <dbAdmin> <dbPassword>
- Windows:
java -classpath
<jdbc_lib_location>\db2jcc.jar;
<jdbc_lib_location>\db2jcc_license_cu.jar;
lib\forum.migrate.jar
;lib\commons-lang-2.0.jar
com.ibm.lconn.forum.
migrate.DescMigrate201To25
db2 <path_to_forumContentStore>
<dbHost> <dbPort>
SNCOMM <dbAdmin> <dbPassword>
db2 -tvf drop201Tables_forum.sql
db2 -tvf appGrants.sql
db2 -tvf appGrants_forum.sql
- (For DB2 9.1 users only)
db2 -tvf db291settings.sql
- Dogear: Wizards/connections.sql/ dogear/db2
db2 -tvf upgrade25.sql
db2 -tvf appGrants.sql
- (For DB2 9.1 users only)
db2 -tvf db291settings.sql
- Home page: Wizards/connections.sql/ homepage/db2
db2 -tvf upgrade25.sql
db2 -tvf appGrants.sql
- (For DB2 9.1 users only)
db2 -tvf db291settings.sql
- Profiles: Wizards/connections.sql/ profiles/db2
db2 -tvf upgrade25a.sql
- cd Wizards and enter the following commands:
- AIX or Linux:
java -classpath
<jdbc_lib_location>/db2jcc.jar:
<jdbc_lib_location>/db2jcc_license_cu.jar:
lib/profiles.migrate.jar:
lib/peoplepages.svcapi.jar:
lib/commons-logging-1.0.4.jar
com.ibm.profiles.
migrate.MigrateEmployeeTable
jdbc:db2://<dbHost>:<dbPort>/peopledb
<dbAdmin> <dbPassword>
- Windows:
java -classpath
<jdbc_lib_location>\db2jcc.jar;
<jdbc_lib_location>\db2jcc_license_cu.jar;
lib\profiles.migrate.jar;
lib\peoplepages.svcapi.jar;
lib\commons-logging-1.0.4.jar
com.ibm.profiles.
migrate.MigrateEmployeeTable
jdbc:db2://<dbHost>:
<dbPort>/peopledb
<dbAdmin> <dbPassword>
db2 -tvf upgrade25b.sql
db2 -tvf appGrants.sql
- (For DB2 9.1 users only)
db2 -tvf db291settings.sql
- Oracle:
- Change to the containing the scripts, as shown in the following list.
- For each feature, enter the following command and then run the appropriate scripts:
sqlplus /as sysdba
- Activities: Wizards/connections.sql/activities/oracle
@upgrade25.sql <dbPassword>
@clearScheduler.sql
@appGrants.sql
- Blogs: Wizards/connections.sql/ blogs/oracle
@upgrade25.sql <dbPassword>
- cd Wizards and enter the following commands:
- AIX or Linux:
java -classpath
<jdbc_lib_location>/ojdbc14.jar:
lib\blogs.migration.jar:
lib/commons-lang-2.0.jar
org.apache.roller.migrate.
MigrateBlogsTo_2_5
oracle <dbName>
<dbHost> <dbPort>
<dbAdmin> <dbPassword>
- Windows:
java -classpath
<jdbc_lib_location>\ojdbc14.jar;
lib\blogs.migration.jar;
lib\commons-lang-2.0.jar
org.apache.roller.migrate.
MigrateBlogsTo_2_5
oracle <dbName>
<dbHost> <dbPort>
<dbAdmin> <dbPassword>
@appGrants.sql
- Communities: Wizards/connections.sql/ communities/oracle
@upgrade25.sql <dbPassword>>
@upgrade25_forum.sql
@uninteg_forum.sql
- cd Wizards and enter the following commands:
- AIX or Linux:
java -classpath
<jdbc_lib_location>/db2jcc.jar:
<jdbc_lib_location>/db2jcc_license_cu.jar:
lib/forum.migrate.jar:
lib/commons-lang-2.0.jar
com.ibm.lconn.forum.
migrate.Migrate201To25
oracle <dbHost> <dbPort>
<dbName> <dbAdmin> <dbPassword>
- Windows:
java -classpath
<jdbc_lib_location>\db2jcc.jar;
<jdbc_lib_location>\db2jcc_license_cu.jar;
lib\forum.migrate.jar;
lib\commons-lang-2.0.jar
com.ibm.lconn.forum.
migrate.Migrate201To25
oracle <dbHost> <dbPort>
<dbName> <dbAdmin> <dbPassword>
@integ_forum.sql
@oraintegOff.sql
- cd Wizards and enter the following commands:
- AIX or Linux:
java -classpath
<jdbc_lib_location>/db2jcc.jar:
<jdbc_lib_location>/db2jcc_license_cu.jar:
lib/sncomm.migrate.jar:
lib/commons-lang-2.0.jar
com.ibm.tango.migrate.
MigrateCommunitiesTo_2_5
oracle <dbName> <dbHost> <dbPort>
<dbAdmin> <dbPassword>
- Windows:
java -classpath
<jdbc_lib_location>\db2jcc.jar;
<jdbc_lib_location>\db2jcc_license_cu.jar;
lib\sncomm.migrate.jar;
lib\commons-lang-2.0.jar
com.ibm.tango.migrate.
MigrateCommunitiesTo_2_5
oracle <dbName> <dbHost> <dbPort>
<dbAdmin> <dbPassword>
@oraintegOn.sql
- Ensure that the forum content store is accessible: From a command prompt, change to the Wizards and enter the following commands:
- AIX or Linux:
java -classpath
<jdbc_lib_location>/db2jcc.jar:
<jdbc_lib_location>/db2jcc_license_cu.jar:
lib/forum.migrate.jar:
lib/commons-lang-2.0.jar
com.ibm.lconn.forum.
migrate.DescMigrate201To25
oracle <path_to_forumContentStore>
<dbHost> <dbPort>
<dbName> <dbAdmin> <dbPassword>
- Windows:
java -classpath
<jdbc_lib_location>\db2jcc.jar;
<jdbc_lib_location>\db2jcc_license_cu.jar;
lib\forum.migrate.jar;
lib\commons-lang-2.0.jar
com.ibm.lconn.forum.
migrate.DescMigrate201To25
oracle <path_to_forumContentStore>
<dbHost> <dbPort>
<dbName> <dbAdmin> <dbPassword>
@drop201Tables_forum.sql
@appGrants.sql
@appGrants_forum.sql
- Dogear: Wizards/connections.sql/ dogear/oracle
@upgrade25.sql <dbPassword>
@appGrants.sql
- Home page: Wizards/connections.sql/ homepage/oracle
@upgrade25.sql <dbPassword>
@appGrants.sql
- Profiles: Wizards/connections.sql/ profiles/oracle
@upgrade25a.sql <dbPassword>
- cd Wizards and enter the following commands:
- AIX or Linux:
java -classpath
<jdbc_lib_location>/ojdbc14.jar:
lib/profiles.migrate.jar:
lib/peoplepages.svcapi.jar:
lib/commons-logging-1.0.4.jar
com.ibm.profiles.
migrate.MigrateEmployeeTable
jdbc:oracle:thin:@
<dbHost>:<dbPort>:<dbName>
<dbAdmin> <dbPassword>
- Windows:
java -classpath
<jdbc_lib_location>\ojdbc14.jar;
lib\profiles.migrate.jar;
lib\peoplepages.svcapi.jar;
lib\commons-logging-1.0.4.jar
com.ibm.profiles.
migrate.MigrateEmployeeTable
jdbc:oracle:thin:@
<dbHost>:<dbPort>:<dbName>
<dbAdmin> <dbPassword>
@upgrade25b.sql
@appGrants.sql
SQL Server 2005
- Login in as the database administrator.
- Change to the containing the scripts.
- For each feature, run the appropriate scripts by entering the commands shown in the following list. In these commands, <dbPassword> is the password for the SQL Server user named sa. If your database server has multiple SQL Server instances installed, add the following text as the first parameter to each command:
-S <sqlserver_server_name>\<sqlserver_server_instance_name>
where <sqlserver_server_name> is the name of your SQL Server database server and <sqlserver_server_instance_name> is the name of your current instance.
- Activities: Wizards\connections.sql\ activities\sqlserver
sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "upgrade25.sql"
sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "clearScheduler.sql"
sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "appGrants.sql"
- Blogs: Wizards\connections.sql\ blogs\sqlserver
sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "upgrade25.sql"
cd Wizards and enter the following commands:
java -classpath
<jdbc_lib_location>\sqljdbc.jar;
lib\blogs.migration.jar;
lib\commons-lang-2.0.jar
org.apache.roller.migrate.
MigrateBlogsTo_2_5
sqlserver BLOGS
<dbHost> <dbPort>
<dbAdmin> <dbPassword>
sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "appGrants.sql"
- Communities: Wizards/connections.sql/ communities/sqlserver
sqlcmd -U <dbAdmin> -P <dbPassword> -i "upgrade25.sql"
sqlcmd -U <dbAdmin> -P <dbPassword> upgrade25_forum.sql
sqlcmd -U <dbAdmin> -P <dbPassword> uninteg_forum.sql
cd Wizards and enter the following commands:
java -classpath
<jdbc_lib_location>\db2jcc.jar;
<jdbc_lib_location>\db2jcc_license_cu.jar;
lib\forum.migrate.jar;
lib\commons-lang-2.0.jar
com.ibm.lconn.forum.
migrate.Migrate201To25
sqlserver <dbHost> <dbPort>
SNCOMM <dbAdmin> <dbPassword>
sqlcmd -U <dbAdmin> -P <dbPassword> integ_forum.sql
sqlcmd -U <dbAdmin> -P <dbPassword> integOff.sql
cd Wizards and enter the following commands:
java -classpath
<jdbc_lib_location>\db2jcc.jar;
<jdbc_lib_location>\db2jcc_license_cu.jar;
lib\sncomm.migrate.jar;
lib\commons-lang-2.0.jar
com.ibm.tango.migrate.
MigrateCommunitiesTo_2_5
sqlserver SNCOMM <dbHost> <dbPort>
<dbAdmin> <dbPassword>
sqlcmd -U <dbAdmin> -P <dbPassword> integOn.sql
Ensure that the forum content store is accessible: from a command prompt, change to the Wizards and enter the following commands:
java -classpath
<jdbc_lib_location>\db2jcc.jar;
<jdbc_lib_location>\db2jcc_license_cu.jar;
lib\forum.migrate.jar;
lib\commons-lang-2.0.jar
com.ibm.lconn.forum.
migrate.DescMigrate201To25
sqlserver <path_to_forumContentStore>
<dbHost> <dbPort>
SNCOMM <dbAdmin> <dbPassword>
sqlcmd -U <dbAdmin> -P <dbPassword> drop201Tables_forum.sql
sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "appGrants.sql"
sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "appGrants_forum.sql"
- Dogear: Wizards\connections.sql\ dogear\sqlserver
sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "upgrade25.sql"
sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "appGrants.sql"
- Home page: Wizards\connections.sql\ homepage\sqlserver
sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "upgrade25.sql"
sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "appGrants.sql"
- Profiles: Wizards\connections.sql\ profiles\sqlserver
sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "upgrade25a.sql"
cd Wizards and enter the following commands:
java -classpath
<jdbc_lib_location>\sqljdbc.jar;
lib\profiles.migrate.jar;
lib\peoplepages.svcapi.jar;
lib\commons-logging-1.0.4.jar
com.ibm.profiles.
migrate.MigrateEmployeeTable
jdbc:sqlserver://
<dbHost>:<dbPort>;databaseName=PEOPLEDB
<dbAdmin> <dbPassword>
sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "upgrade25b.sql"
sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "appGrants.sql"
- If you plan to install the Files and Wikis features, create databases for them now, using the Lotus Connections 2.5 database wizard.
- Check that all the databases are working correctly.
- Migrate your Lotus Connections release 2.0.1 deployment to release 2.5.
Updating Lotus Connections 2.5