Creating a DB2 database for Windows, Linux, AIX, and Solaris 

---

Create the database tables and schema needed by Sametime® Gateway. These steps assume that you already have installed DB2® on the same machine on which you are now creating the database. If the machine on which you installed DB2 is named STGW, follow the steps in this procedure to change the name of the database in the database creation script. The default database name, STGW, cannot be the machine name.

Before you begin

The Sametime Gateway installation package includes a database creation script, which creates the database. Follow the steps below to unpack the installation compressed file and extract the contents before you run the script.

Expected state: DB2 is installed and running.

Procedure

1. From the installation media, copy the Sametime Gateway installation image for your operating system to a temporary directory on the DB2 server node:
   
The part numbers for each product are available at the following Web address:

https://www-304.ibm.com/support/docview.wss?rs=477&uid=swg24029128
• Windows:

\TMP\SametimeGateway\part_number.exe



• Linux, AIX, or Solaris:

  /TMP/SametimeGateway/part_number.tar



2. Open a command window and navigate to the temporary directory.
3. Unzip the installation image to the /TMP/SametimeGateway folder.
4. Log in to the operating system using the DB2 administrator account created when you installed DB2.
5. On the node where you will be creating the database Sametime Gateway, open a command window and type one of the following commands:
• Windows:

db2cmd



• Linux or AIX:

. /db2adminHomeDir/sqllib/db2profile



• Note the period (.) and space before /db2adminHomeDir/sqllib/db2profile.
• Solaris:

. /db2adminHomeDir/sqllib/db2profile



6. If the host name on which you installed DB2 is named STGW, or if you need to change the database name to something other than STGW, or if your database administrator wishes to specify tablespace options, complete the following sub steps, otherwise skip this step.
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.
3. If desired, you may edit the tablespace file locations for your specific environment to be somewhere other than the default location.
4. Save the file.
   
7. In the DB2 window, navigate to this directory:
   

\TMP\SametimeGateway\database\db2



8. Type the following command to create the database:
   

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:
   
1. db2stop
2. db2start
   

Parent topic: Installing a Sametime Gateway server
Next topic: Installing Sametime Gateway