Creating the Sametime Gateway database
Create the database tables and schema needed by Sametime® Gateway Server.
Procedure
- Log on to the DB2® server as the DB2 administrator.
- Find the software packages you need to download.
- Download the packages.
- Extract all downloaded packages.
- From the Sametime Gateway
installation package, copy the
createDb.sql
script to a temporary location on the DB2 server. - 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.- Using a text editor, open
createDb.sql
. - Replace every instance of
STGW
with a new database name that is eight characters or less. - Optionally edit the tablespace file locations.
- Save and close the file.
- Using a text editor, open
- Start the DB2 command
window by running the following command:
- Linux™:
db2
- Windows™:
db2cmd
- Linux™:
- 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. - Stop and then restart the database using the following
commands:
db2stop db2start
- Close the DB2 command window.