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

To update databases manually...

  1. Log in to the WAS admin console.

  2. Go to Applications > Enterprise Applications.

  3. Stop all Lotus Connections features.

  4. 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

      1. Log in as the database administrator.

      2. 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

          1. db2 -tvf upgrade25.sql

          2. db2 -tvf clearScheduler.sql

          3. db2 -tvf appGrants.sql

          4. (For DB2 9.1 users only)

            db2 -tvf db291settings.sql

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

          1. db2 -tvf upgrade25.sql

          2. 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>

          3. db2 -tvf appGrants.sql

          4. (For DB2 9.1 users only)

            db2 -tvf db291settings.sql

        • Communities: Wizards/connections.sql/ communities/db2

          1. db2 -tvf upgrade25.sql

          2. db2 -tvf upgrade25_forum.sql

          3. db2 -tvf uninteg_forum.sql

          4. 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>

          5. db2 -tvf integ_forum.sql

          6. db2 -tvf integOff.sql

          7. 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>

          8. db2 -td@ -vf integOn.sql

          9. 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>

          10. db2 -tvf drop201Tables_forum.sql

          11. db2 -tvf appGrants.sql

          12. db2 -tvf appGrants_forum.sql

          13. (For DB2 9.1 users only)

            db2 -tvf db291settings.sql

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

          1. db2 -tvf upgrade25.sql

          2. db2 -tvf appGrants.sql

          3. (For DB2 9.1 users only)

            db2 -tvf db291settings.sql

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

          1. db2 -tvf upgrade25.sql

          2. db2 -tvf appGrants.sql

          3. (For DB2 9.1 users only)

            db2 -tvf db291settings.sql

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

          1. db2 -tvf upgrade25a.sql

          2. 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>

          3. db2 -tvf upgrade25b.sql

          4. db2 -tvf appGrants.sql

          5. (For DB2 9.1 users only)

            db2 -tvf db291settings.sql

    • Oracle:

      1. Change to the containing the scripts, as shown in the following list.

      2. For each feature, enter the following command and then run the appropriate scripts:

          sqlplus /as sysdba
          

    • Activities: Wizards/connections.sql/activities/oracle

      1. @upgrade25.sql <dbPassword>

      2. @clearScheduler.sql

      3. @appGrants.sql

    • Blogs: Wizards/connections.sql/ blogs/oracle

      1. @upgrade25.sql <dbPassword>

      2. 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>

      3. @appGrants.sql

    • Communities: Wizards/connections.sql/ communities/oracle

      1. @upgrade25.sql <dbPassword>>

      2. @upgrade25_forum.sql

      3. @uninteg_forum.sql

      4. 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>

      5. @integ_forum.sql

      6. @oraintegOff.sql

      7. 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>

      8. @oraintegOn.sql

      9. 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>

      10. @drop201Tables_forum.sql

      11. @appGrants.sql

      12. @appGrants_forum.sql

    • Dogear: Wizards/connections.sql/ dogear/oracle

      1. @upgrade25.sql <dbPassword>

      2. @appGrants.sql

    • Home page: Wizards/connections.sql/ homepage/oracle

      1. @upgrade25.sql <dbPassword>

      2. @appGrants.sql

    • Profiles: Wizards/connections.sql/ profiles/oracle

      1. @upgrade25a.sql <dbPassword>

      2. 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>

      3. @upgrade25b.sql

      4. @appGrants.sql

  • SQL Server 2005

    1. Login in as the database administrator.

    2. Change to the containing the scripts.

    3. 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

        1. sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "upgrade25.sql"

        2. sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "clearScheduler.sql"

        3. sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "appGrants.sql"

      • Blogs: Wizards\connections.sql\ blogs\sqlserver

        1. sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "upgrade25.sql"

        2. 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>

        3. sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "appGrants.sql"

      • Communities: Wizards/connections.sql/ communities/sqlserver

        1. sqlcmd -U <dbAdmin> -P <dbPassword> -i "upgrade25.sql"

        2. sqlcmd -U <dbAdmin> -P <dbPassword> upgrade25_forum.sql

        3. sqlcmd -U <dbAdmin> -P <dbPassword> uninteg_forum.sql

        4. 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>

        5. sqlcmd -U <dbAdmin> -P <dbPassword> integ_forum.sql

        6. sqlcmd -U <dbAdmin> -P <dbPassword> integOff.sql

        7. 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>

        8. sqlcmd -U <dbAdmin> -P <dbPassword> integOn.sql

        9. 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>

        10. sqlcmd -U <dbAdmin> -P <dbPassword> drop201Tables_forum.sql

        11. sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "appGrants.sql"

        12. sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "appGrants_forum.sql"

      • Dogear: Wizards\connections.sql\ dogear\sqlserver

        1. sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "upgrade25.sql"

        2. sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "appGrants.sql"

      • Home page: Wizards\connections.sql\ homepage\sqlserver

        1. sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "upgrade25.sql"

        2. sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "appGrants.sql"

      • Profiles: Wizards\connections.sql\ profiles\sqlserver

        1. sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "upgrade25a.sql"

        2. 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>

        3. sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "upgrade25b.sql"

        4. sqlcmd -d master -U <dbAdmin> -P <dbPassword> -i "appGrants.sql"

    1. If you plan to install the Files and Wikis features, create databases for them now, using the Lotus Connections 2.5 database wizard.

    2. Check that all the databases are working correctly.

    3. Migrate your Lotus Connections release 2.0.1 deployment to release 2.5.


    Updating databases in-place

    Updating Lotus Connections 2.5


    +

    Search Tips   |   Advanced Search