Update 2.5 DB2 databases manually 

Manually update IBM Lotus Connections 2.5 databases to version 3.0.1 in an existing IBM WAS and DB2 database environment.

Before starting

Before applying updates, back up your databases. For more information, see the Backing up IBM Connections topic.

Ensure that you have installed and configured all supporting software for version 3.0.1.

About this task

This topic describes how to manually update Lotus Connections version 2.5 databases to version 3.0.1. Use this procedure if you want an alternative to using the database wizard to update your databases.

Notes:

• Use the Java™ Runtime Environment (JRE) under the Wizards directory in the installation media. Update your PATH variable to point to this JRE, using the instructions for your operating system. For example, the relative path to the JRE on the Microsoft™ Windows™ operating system might be C:\IBM\Lotus_Connections\Wizards\jvm\win\jre. For the AIX or Linux™ operating systems, the relative path might be /Wizards/jvm/aix/jre and /Wizards/jvm/linux/jre.

• Lotus Connections does not support GNU Java.

• You do not need to use a database administrator ID to run the Java migration utilities described in this task. You can use a database user ID, such as lcuser.

• This task creates a Forums database.

• To improve readability, some commands and file paths in this topic are displayed on separate lines. Ignore these formatting conventions when entering the commands.

• After running each command, examine the output of the command for error messages. If you find errors, resolve them before continuing with the update process.

To update databases manually...

Procedure

1. Log in to the WAS admin console on your dmgr.

2. Go to Applications -> Application types -> WebSphere enterprise Applications.

3. Stop all Lotus Connections applications.

4. (DB2 on Windows 2008 64-bit) On Windows 2008, perform DB2 administration tasks with full administrator privileges.

   1. Logged in as the instance owner, open a command prompt and change to the DB2 bin directory. For example: C:\Program Files\IBM\SQLLIB\BIN.

   2. Enter the following command: db2cwadmin.bat. This command opens the DB2 Command Line Processor while also setting your DB2 privileges.
      

5. Log in as the database administrator.

6. For each application, change to the directory where the SQL scripts are stored and then enter the commands for that application.
   
   Note: To capture the output of each command to a log file, append the following parameter to each command: >> /<file_path>/db_<application>.log

   where <file_path> is the full path to the log file and <application> is the name of the log file. For example:

   db2 -tvf createDb.sql >> /home/db2inst1/db_activities.log

   Ensure that you have write permissions for the directories and log files.
   

7. Activities: Wizards/connections.sql/activities/db2

   Note: Before updating the Activities database, update the codepage to Unicode. If you use the system codepage, Unicode data might become corrupted after updating the database. Run the following commands:
   i. db2set DB2CODEPAGE=1208
   ii. db2stop force
   iii. db2start
   

   1. db2 -td@ -vf upgrade-25-30.sql

   2. db2 -td@ -vf appGrants.sql

   3. db2 -td@ -vf upgrade-30-301.sql

   4. db2 -td@ -vf appGrants.sql
      

8. Blogs: Wizards/connections.sql/blogs/db2

   1. db2 -td@ -vf upgrade-25-30.sql

   2. From a command prompt, change to the Wizards directory and enter the following text as a command on a single line:
      

      • AIX or Linux:
        jvm/<OS>/jre/bin/java -classpath

        <jdbc_library_location>/db2jcc.jar:

        <jdbc_library_location>/db2jcc_license_cu.jar:

        lib/lc.dbmigration.default.jar:

        lib/blogs.migrate.jar:

        lib/commons-lang-2.0.jar:

        lib/commons-logging-1.0.4.jar

        com.ibm.lconn.blogs.migration.MigrationFrom25To30

        -dburl jdbc:db2://<dbHost>:<dbPort>/BLOGS

        -dbuser <dbUser> -dbpassword <dbPassword>

        where <OS> is the operating system on which the database is hosted.
        

      • Windows:
        jvm\win\jre\bin\java -classpath

        <jdbc_library_location>\db2jcc.jar;

        <jdbc_library_location>\db2jcc_license_cu.jar;

        lib\lc.dbmigration.default.jar;

        lib\blogs.migrate.jar;

        lib\commons-lang-2.0.jar;

        lib\commons-logging-1.0.4.jar

        com.ibm.lconn.blogs.migration.MigrationFrom25To30

        -dburl jdbc:db2://<dbHost>:<dbPort>/BLOGS

        -dbuser <dbUser> -dbpassword <dbPassword>
        

      where
      

      • <jdbc_library_location> is the location of your JDBC driver

      • <dbHost> is the name of the system hosting your database

      • <dbPort> is the communications port of the database

      • <dbAlias> is the reserved name of the database, if applicable

      • <dbUser> is the database user ID

      • <dbPassword> is the administrator password

   3. db2 -td@ -vf appGrants.sql

   4. db2 -td@ -vf upgrade-30-301.sql

   5. From a command prompt, change to the Wizards directory and enter the following text as a command on a single line:
      

      • AIX or Linux:
        jvm/<OS>/jre/bin/java -classpath

        <jdbc_library_location>/db2jcc.jar:

        <jdbc_library_location>/db2jcc_license_cu.jar:

        lib/lc.dbmigration.default.jar:

        lib/blogs.migrate.jar:

        lib/commons-lang-2.0.jar:

        lib/commons-logging-1.0.4.jar

        com.ibm.lconn.blogs.migration.MigrationFrom30To301

        -dburl jdbc:db2://<dbHost>:<dbPort>/BLOGS

        -dbuser <dbUser> -dbpassword <dbPassword>

        where <OS> is the operating system on which the database is hosted.
        

      • Windows:
        jvm\win\jre\bin\java -classpath

        <jdbc_library_location>\db2jcc.jar;

        <jdbc_library_location>\db2jcc_license_cu.jar;

        lib\lc.dbmigration.default.jar;

        lib\blogs.migrate.jar;

        lib\commons-lang-2.0.jar;

        lib\commons-logging-1.0.4.jar

        com.ibm.lconn.blogs.migration.MigrationFrom30To301

        -dburl jdbc:db2://<dbHost>:<dbPort>/BLOGS

        -dbuser <dbUser> -dbpassword <dbPassword>
        

      where
      

      • <jdbc_library_location> is the location of your JDBC driver

      • <dbHost> is the name of the system hosting your database

      • <dbPort> is the communications port of the database

      • <dbAlias> is the reserved name of the database, if applicable

      • <dbUser> is the database user ID

      • <dbPassword> is the administrator password

   6. db2 -td@ -vf appGrants.sql
      

9. Communities: Wizards/connections.sql/forum/db2
   
   These commands create a Forums database and then update the Communities database. Before running these commands, be logged in as the database instance owner.
   

   1. db2 -td@ -vf createDb.sql

   2. db2 -td@ -vf appGrants.sql

   3. db2 -td@ -vf uninteg.sql

   4. From a command prompt, change to the Wizards directory and enter the following text as a single command:
      

      • AIX or Linux:
        jvm/<OS>/jre/bin/java -classpath

        <jdbc_library_location>/db2jcc.jar:

        <jdbc_library_location>/db2jcc_license_cu.jar:

        lib/lc.dbmigration.default.jar:

        lib/forum.migrate.jar:

        lib/commons-lang-2.0.jar:

        lib/commons-logging-1.0.4.jar

        com.ibm.lconn.forum.migration.MigrationFrom25To30

        -dburl "jdbc:db2://<3.0.1_dbHost>:<3.0.1_dbPort>/FORUM"

        -dbuser <3.0.1_dbAdmin> -dbpassword <3.0.1_dbPassword>

        -srcdburl "jdbc:db2://<2.5_dbHost>:<2.5_dbPort>/SNCOMM"

        -srcdbuser <2.5_dbUser> -srcdbpassword <2.5_dbPassword>
        

      • Windows:
        jvm\win\jre\bin\java -classpath

        <jdbc_library_location>\db2jcc.jar;

        <jdbc_library_location>\db2jcc_license_cu.jar;

        lib\lc.dbmigration.default.jar;

        lib\forum.migrate.jar;

        lib\commons-lang-2.0.jar;

        lib\commons-logging-1.0.4.jar

        com.ibm.lconn.forum.migration.MigrationFrom25To30

        -dburl "jdbc:db2://<3.0.1_dbHost>:<3.0.1_dbPort>/FORUM"

        -dbuser <3.0.1_dbAdmin> -dbpassword <3.0.1_dbPassword>

        -srcdburl "jdbc:db2://<2.5_dbHost>:<2.5_dbPort>/SNCOMM"

        -srcdbuser <2.5_dbAdmin> -srcdbpassword <2.5_dbPassword>
        

      where
      

      • <3.0.1_dbHost> is the name of the system hosting your IBM Connections 3.0.1 database

      • <3.0.1_dbPort> is the communications port of the database

      • <3.0.1_dbAdmin> is the 3.0.1 database administrator ID

      • <3.0.1_dbPassword> is the administrator password

      • <2.5_dbHost> is the name of the system hosting your Lotus Connections 2.5 database

      • <2.5_dbPort> is the communications port for the database

      • <2.5_dbAdmin> is the 2.5 database administrator ID

      • <2.5_dbPassword> is the administrator password

   5. db2 -td@ -vf integ.sql

   6. Change to the Wizards/connections.sql/communities/db2 directory and run the scripts in the following steps.

   7. db2 -td@ -vf drop_lc25_forum_tables.sql

   8. db2 -td@ -vf upgrade-25-30a.sql

   9. db2 -td@ -vf upgrade-25-30b.sql

   10. db2 -td@ -vf appGrants.sql

   11. db2 -td@ -vf upgrade-30-301.sql

   12. db2 -td@ -vf appGrants.sql
       

10. Dogear: Wizards/connections.sql/dogear/db2

    1. db2 -td@ -vf upgrade-25-30.sql
       

    2. db2 -td@ -vf appGrants.sql
       

    3. db2 -td@ -vf upgrade-30-301.sql
       

    4. db2 -td@ -vf appGrants.sql
       

11. Files: Wizards/connections.sql/files/db2

    1. db2 -td@ -vf upgrade-25-30.sql
       

    2. db2 -td@ -vf appGrants.sql
       

    3. db2 -td@ -vf upgrade-30-301.sql
       

    4. db2 -td@ -vf appGrants.sql
       

12. Home page: Wizards/connections.sql/homepage/db2

    1. db2 -tvf upgrade-25-30a.sql
       

    2. db2 -tvf upgrade-25-30b.sql
       

    3. db2 -tvf appGrants.sql
       

    4. From a command prompt, change to the Wizards directory and enter the following text as a single command:
       

       • AIX or Linux:
         jvm/<OS>/jre/bin/java -classpath

         <jdbc_library_location>/db2jcc.jar:

         <jdbc_library_location>/db2jcc_license_cu.jar:

         lib/news.migrate.jar:

         lib/news.core.data.jar:

         lib/news.core.service.jar:

         lib/news.common.jar:

         lib/lc.admin.userlifecycle.spi.jar:

         lib/lc.events.newsEjbConsumer.jar:

         lib/lc.dbmigration.default.jar:

         lib/ibatis-2.3.0.677.jar:

         lib/spring.jar:

         lib/commons-logging-1.0.4.jar:

         lib/commons-dbcp-1.2.1.jar:

         lib/commons-collections-3.2.1.jar:

         lib/commons-pool-1.2.jar:

         lib/commons-lang-2.4.jar

         com.ibm.lconn.news.migration.EmailDigestMigrationFrom25To30
         Note: If you receive an Out Of Memory exception when running this command, you need to increase the memory allocation. Run the command again but with the -Xmx parameter. For example: -Xmx512 com.ibm.lconn.news.migration.EmailDigestMigrationFrom25To30

         -dburl jdbc:db2://<dbHost>:<dbPort>/HOMEPAGE

         -dbuser <dbUser> -dbpassword <dbPassword>

         where <OS> is the operating system on which the database is hosted.
         

       • Windows:
         jvm\win\jre\bin\java -classpath

         <jdbc_library_location>\db2jcc.jar;

         <jdbc_library_location>\db2jcc_license_cu.jar;

         lib\news.migrate.jar;

         lib\news.core.data.jar;

         lib\news.core.service.jar;

         lib\news.common.jar;

         lib\lc.admin.userlifecycle.spi.jar;

         lib\lc.events.newsEjbConsumer.jar;

         lib\lc.dbmigration.default.jar;

         lib\ibatis-2.3.0.677.jar;

         lib\spring.jar;

         lib\commons-logging-1.0.4.jar;

         lib\commons-dbcp-1.2.1.jar;

         lib\commons-collections-3.2.1.jar;

         lib\commons-pool-1.2.jar;

         lib\commons-lang-2.4.jar

         com.ibm.lconn.news.migration.EmailDigestMigrationFrom25To30
         Note: If you receive an Out Of Memory exception when running this command, you need to increase the memory allocation. Run the command again but with the -Xmx parameter. For example: -Xmx512 com.ibm.lconn.news.migration.EmailDigestMigrationFrom25To30

         -dburl jdbc:db2://<dbHost>:<dbPort>/HOMEPAGE

         -dbuser <dbUser> -dbpassword <dbPassword>
         

    5. Enter the following text as a single command:
       

       • AIX or Linux:
         jvm/<OS>/jre/bin/java -classpath

         <jdbc_library_location>/db2jcc.jar:

         <jdbc_library_location>/db2jcc_license_cu.jar:

         lib/news.migrate.jar:

         lib/news.core.data.jar:

         lib/news.core.service.jar:

         lib/news.common.jar:

         lib/lc.admin.userlifecycle.spi.jar:

         lib/lc.events.newsEjbConsumer.jar:

         lib/lc.dbmigration.default.jar:

         lib/ibatis-2.3.0.677.jar:

         lib/spring.jar:

         lib/commons-logging-1.0.4.jar:

         lib/commons-dbcp-1.2.1.jar:

         lib/commons-collections-3.2.1.jar:

         lib/commons-pool-1.2.jar:

         lib/commons-lang-2.4.jar

         com.ibm.lconn.news.migration.NewsMigrationFrom25To30

         -dburl jdbc:db2://<dbHost>:<dbPort>/HOMEPAGE

         -dbuser <dbUser> -dbpassword <dbPassword>

         where <OS> is the operating system on which the database is hosted.
         

       • Windows:
         jvm\win\jre\bin\java -classpath

         <jdbc_library_location>\db2jcc.jar;

         <jdbc_library_location>\db2jcc_license_cu.jar;

         lib\news.migrate.jar;

         lib\news.core.data.jar;

         lib\news.core.service.jar;

         lib\news.common.jar;

         lib\lc.admin.userlifecycle.spi.jar;

         lib\lc.events.newsEjbConsumer.jar;

         lib\lc.dbmigration.default.jar;

         lib\ibatis-2.3.0.677.jar;

         lib\spring.jar;

         lib\commons-logging-1.0.4.jar;

         lib\commons-dbcp-1.2.1.jar;

         lib\commons-collections-3.2.1.jar;

         lib\commons-pool-1.2.jar;

         lib\commons-lang-2.4.jar

         com.ibm.lconn.news.migration.NewsMigrationFrom25To30

         -dburl jdbc:db2://<dbHost>:<dbPort>/HOMEPAGE

         -dbuser <dbUser> -dbpassword <dbPassword>
         

    6. db2 -tvf upgrade-30-301.sql
       

    7. db2 -tvf appGrants.sql
       

13. Profiles: Wizards/connections.sql/profiles/db2

    1. db2 -tvf upgrade-25-30.sql
       

    2. db2 -tvf appGrants.sql
       

    3. db2 -tvf upgrade-30-301.sql
       

    4. db2 -tvf appGrants.sql
       

14. Wikis: Wizards/connections.sql/wikis/db2

    1. db2 -td@ -vf upgrade-25-30.sql
       

    2. db2 -td@ -vf appGrants.sql
       

    3. db2 -td@ -vf upgrade-30-301.sql
       

    4. db2 -td@ -vf appGrants.sql
       

15. Migrate your 2.5 themes: From a command prompt, change to the Wizards directory and enter the following text as a single command:
    

    • AIX or Linux:
      jvm/<OS>/jre/bin/java -classpath

      <jdbc_library_location>/db2jcc.jar:

      <jdbc_library_location>/db2jcc_license_cu.jar:

      lib/lc.dbmigration.default.jar:

      lib/sncomm.migrate.jar:

      lib/commons-lang-2.0.jar:

      lib/commons-logging-1.0.4.jar

      com.ibm.tango.migrate.MigrateCommunityTheme_2_5_To_3_0

      -source db2 SNCOMM <2.5_dbHost> <2.5_dbPort> <2.5_dbUser> <2.5_dbPassword>

      -target db2 <3.0.1_database> <3.0.1_dbHost> <3.0.1_dbPort> <3.0.1_dbAdmin><3.0.1_dbPassword>
      

    • Windows:
      jvm\win\jre\bin\java -classpath

      <jdbc_library_location>\db2jcc.jar;

      <jdbc_library_location>\db2jcc_license_cu.jar;

      lib\lc.dbmigration.default.jar;

      lib\sncomm.migrate.jar;

      lib\commons-lang-2.0.jar;

      lib\commons-logging-1.0.4.jar

      com.ibm.tango.migrate.MigrateCommunityTheme_2_5_To_3_0

      -source db2 SNCOMM <2.5_dbHost> <2.5_dbPort> <2.5_dbUser> <2.5_dbPassword>

      -target db2 <3.0.1_database> <3.0.1_dbHost> <3.0.1_dbPort> <3.0.1_dbAdmin><3.0.1_dbPassword>
      

    where
    

    • <2.5_dbHost> is the name of the system hosting your Lotus Connections 2.5 database,

    • <2.5_dbPort> is the communications port for the database

    • <2.5_dbAdmin> is the 2.5 database administrator ID

    • <2.5_dbPassword> is the administrator password

    • <3.0.1_database> is the database for the Activities, Blogs, and Wikis applications

    • <3.0.1_dbHost> is the name of the system hosting your IBM Connections 3.0.1 database

    • <3.0.1_dbPort> is the communications port for the database

    • <3.0.1_dbAdmin> is the 3.0.1 database administrator ID

    • <3.0.1_dbPassword> is the administrator password

What to do next

Check that all the databases are working correctly.

(DB2 for Linux on System z only.) To improve database performance, enable the NO FILE SYSTEM CACHING option. For more information, see the Enable NO FILE SYSTEM CACHING for DB2 on System z topic.

Parent topic

Update 2.5 databases manually

+

Search Tips   |   Advanced Search