Create a new database and migrate existing policy information
from IBM® Sametime® 8.5.2x to Sametime 9 on an IBM DB2® server
running on IBM AIX®, Linux,
or Microsoft Windows.
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. 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 (if different),
and the Sametime 9 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 (AIX, 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
- AIX or 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
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 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
by completing the steps in Creating a database
for the Sametime System
Console.
If Sametime 8.5.2x and Sametime 9 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 (AIX, 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
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 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
- AIX or 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 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
System Console.
- If you are already logged in to the Sametime 9 System Console,
log out now.
- Log in to the Sametime 9
System Console.
- Click .