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
- On the DB2 server
where the Sametime 8.5.2x
databases are stored, log in as the DB2 administrator.
-
Download the exportPolicies.bat (Windows™) or exportPolicies.sh (Linux™) script from the IBM Technote Sametime 8.5.2.x Migration to Sametime 9.
- Open a command window.
- 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
-
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.
-
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).
-
Move to the DB2 server for Sametime 9.0.1 and log in as the DB2 administrator.
-
Paste the directory containing the data that you exported from Sametime 8.5.2x.
-
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.
- Open a command window.
-
Download the importPolicies.bat (Windows) or importPolicies.sh (Linux) script from the IBM Technote Sametime 8.5.2.x Migration to Sametime 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
-
Move to the Sametime 9.0.1 System Console.
-
If you are already logged in to the Sametime 9.0.1
System Console, log out now.
-
Log in to the Sametime 9.0.1 System Console.
- Click .