Migrating DB2 databases to Sametime 9.0.1 format

Upgrade IBM® DB2® databases, migrate policies data, and optionally upgrade the DB2 server.

About this task

The migration process in this documentation enables you to use most of the existing databases in both the existing Sametime® 8.5.2x deployment and the new Sametime 9.0.1 deployment at the same time; only the Sametime 9.0.1 System Console and the Sametime 9.0.1 Community Server receive new databases. Changes to database schemas and tables in Sametime 9.0.1 support new features that were not available in Sametime 8.5.2x, and will be ignored by the old deployment.

The Sametime databases in DB2 require the following updates for Sametime 9.0.1:
  • Sametime System Console: Export the Policy database, update policies, and import them to a new Policy database using a new database name. Existing policy settings will be preserved.
  • Sametime Meeting Server: Schema update required to support new features. The update does not impact existing meetings.
  • Sametime Advanced Server: No changes to schema but you must add 3 items to the database for default configuration settings.
  • Sametime Proxy Server: No changes.
  • Sametime Gateway: No changes.
  • Sametime Bandwidth Manager: No changes.
Note: DB2 has discontinued the DB2 Control Center and requires that you modify databases data using IBM Data Studio. If you are unfamiliar with Data Studio, you can migrate DB2 databases to the Sametime 9.0.1 formats using DB2 9.x and the DB2 Control Center before upgrading the DB2 server to V10.5.