Creating the Sametime Gateway database schemas and tables on IBM i

Before you install IBM® Sametime® Gateway, you must create the DB2® database, including tables and bufferpools, needed by Sametime Gateway. Sametime Gateway stores community settings and custom properties in the database.

About this task

For a multiserver installation, you should perform the steps once on the IBM i server where you want to host the data for Sametime Gateway Server. Afterwards, when you install Sametime Gateway Server, you use the host name of that IBM i server when specifying the server name on the database information panel of the wizard.

On the IBM i system that will host your database, proceed as follows:

Procedure

  1. Create a user profile on the system that will be the owner of the schema created for the Sametime Gateway Server data. The profile that you create can have a user class of *USER, and will not require special authorities.
  2. Log in as the profile that will be the owner of the schema.
  3. Find the software packages you need to download.
  4. Download the packages.
  5. Extract all downloaded packages.
  6. From the installation package, copy the createDbi5OS script to a temporary location.
  7. Start a QSHELL session by running the following command: 
    QSH
  8. Change to the directory where you copied the file createDbi5OS script, and run the following command: 
    createDbi5OS Schema_Name

    Where Schema_Name is the unique name of the Sametime Gateway schema that you are creating.