Migrating policies to Sametime 9.0.1

Create a new database and migrate existing policy information from IBM® Sametime® 8.5.2x to Sametime 9.0.1 on an IBM DB2® server.

Before you begin

This task requires you to download files for use during the migration process. You can obtain the files from the IBM Technote Sametime 8.5.2.x Migration to Sametime 9. The files are attached directly to the technote and are described in the following procedure.

About this task

Sametime policies are stored in the Sametime System Console database on the DB2 server. Migrate the policies by exporting table data from the original database and importing the data into a new database for Sametime 9.0.1. During the migration, new fields and templates will be added to the tables, but the existing policy settings will not be affected.

To complete this task, you will work with the DB2 server for Sametime 8.5.2x, the DB2 server for Sametime 9.0.1 (if different), and the Sametime 9.0.1 System Console.

Procedure

  1. On the DB2 server where the Sametime 8.5.2x databases are stored, log in as the DB2 administrator.
  2. Download the exportPolicies.bat (Windows™) or exportPolicies.sh (Linux™) script from the IBM Technote Sametime 8.5.2.x Migration to Sametime 9.
  3. Open a command window.
  4. Export the TEMPLATE and ASSIGNMENT table data from the System Console database by running the following command:
    • Windows:
      exportPolicies.bat ST852_database_name Path_to_store_exports
      Where:
      • ST852_database_name is the name of the System Console database for version 8.5.2x (the default is STSC).
      • Path_to_store_exports is the path to the directory where you want to store the exported data.
      For example:
      exportPolicies.bat STSC c:\exported_policies
    • Linux:
      sh exportPolicies.sh ST852_database_name Path_to_store_exports
      Where:
      • ST852_database_name is the name of the System Console database for version 8.5.2x (the default is STSC).
      • Path_to_store_exports is the path to the directory where you want to store the exported data.
      For example:
      sh exportPolicies.sh STSC /opt/IBM/DatabaseScripts/exported_policies
  5. If the Sametime 9.0.1 System Console database will be stored on a different DB2 server from the Sametime 8.5.2x database, complete the following steps:

    If both versions of the database will be stored on the same DB2 server, you can skip to step 6.

    1. On the DB2 server used for Sametime 8.5.2x, copy the directory containing the exported data (the exported_policies directory in the export example).
    2. Move to the DB2 server for Sametime 9.0.1 and log in as the DB2 administrator.
    3. Paste the directory containing the data that you exported from Sametime 8.5.2x.
  6. Create a new System Console database to contain the policies data for Sametime 9.0.1 by completing the steps in Creating a database for the Sametime System Console.

    If Sametime 8.5.2x and Sametime 9.0.1 use the same DB2 server, make sure you give the new database a new name to avoid overwriting the existing version of the database.

  7. Open a command window.
  8. Download the importPolicies.bat (Windows) or importPolicies.sh (Linux) script from the IBM Technote Sametime 8.5.2.x Migration to Sametime 9.
  9. Import the TEMPLATE and ASSIGNMENT table data to the new Sametime 9.0.1 System Console database by running the following command:
    • Windows:
      importPolicies.bat ST9_database_name Path_to_exported_data
      Where:
      • ST9_database_name is the name of the System Console database that you created for Sametime 9.0.1 in step 6.
      • Path_to_exported_data is the path to the directory containing the data that you exported from Sametime 8.5.2x.
      For example:
      importPolicies.bat STSC_9 c:\exported_policies
    • Linux:
      sh importPolicies.sh ST9_database_name Path_to_exported_data
      Where:
      • ST9_database_name is the name of the System Console database that you created for Sametime 9.0.1 in step 4.
      • Path_to_exported_data is the path to the directory containing the data that you exported from Sametime 8.5.2x.
      For example:
      sh importPolicies.sh STSC_9 /opt/IBM/DatabaseScripts/exported_policies
  10. Move to the Sametime 9.0.1 System Console.
  11. If you are already logged in to the Sametime 9.0.1 System Console, log out now.
  12. Log in to the Sametime 9.0.1 System Console.
  13. Click Manage Policies > Edit Policy Settings > Update Policies > Apply.