Creating the Sametime Gateway database

Create the database tables and schema needed by Sametime® Gateway Server.

Procedure

  1. Log on to the DB2® server as the DB2 administrator.
  2. Find the software packages you need to download.
  3. Download the packages.
  4. Extract all downloaded packages.
  5. From the Sametime Gateway installation package, copy the createDb.sql script to a temporary location on the DB2 server.
  6. If the DB2 server's host name is STGW, change the name that will be used for the new database so that you avoid any conflicts.
    1. Using a text editor, open createDb.sql.
    2. Replace every instance of STGW with a new database name that is eight characters or less.

      When naming DB2 objects, follow the rules for your operating system.

    3. Optionally edit the tablespace file locations.
    4. Save and close the file.
  7. Start the DB2 command window by running the following command:
    • Linux™: db2
    • Windows™: db2cmd
  8. Create the Sametime Gateway database by running the createDb.sql script: 
    db2 -tvf createDb.sql > createDbOut.txt
    If you edited the createDb.sql file, inspect the createDbOut.txt file to be sure that all commands executed correctly.
  9. Stop and then restart the database using the following commands:
    db2stop
db2start
  10. Close the DB2 command window.