Updating the database schema for Sametime Meeting Server

Update the database schema for the IBM® Sametime® Meeting Server. This task does not affect existing data.

About this task

Using the existing Sametime 8.5.2x Meeting Server database requires that you update the schema by adding tables to support new features for Sametime 9.0.1. This change does not affect existing data.

Procedure

  1. On the Sametime 9.0.1 Meeting Server, log in as the system administrator (Windows™), or as root (Linux™).
  2. Open a command window.
  3. Navigate to the directory where you extracted the Sametime 9.0.1 Meeting Server installation package.
  4. From the installation package, navigate to the SametimeMeetingServer/DatabaseScripts folder.
  5. Update the schema by running the following command:
    • Windows: 
      applyDDLUpdate.bat migration_meetingserver_ddl_filename Database_name DB2admin_user_name
      For example: 
      applyDDLUpdate.bat migration_meetingServer_85x-90.ddl STMS db2admin
    • Linux: 
      ./applyDDLUpdate.sh migration_meetingserver_ddl_filename Database_name DB2admin_user_name
    Where:
    • Database_name is the name of the Sametime 8.5.2x Meeting Server database; the default name is STMS.
    • DB2admin_user_name is the user name of the DB2® administrator account that has the authority to modify the database.

    Wait until you see confirmation that the command has finished.