Creating the Sametime System Console database schemas and tables on IBM i

Run the createSCDb.sh script to create the database schema for the IBM® Sametime® System Console on IBM i.

Before you begin

Create a DB2ADMIN profile, and then edit the createSCDb.sh script and change the default DB2 administrator user name and password to match what you used in the profile. Using the default values is considered a security risk.

About this task

On the IBM i server on which you are installing the Sametime System Console, complete these steps to create the database schema and tables:

Procedure

  1. Log in to the server using a profile with *ALLOBJ and *SECADM special authorities.
  2. From an IBM i command line, run the following command to start the QShell Interpreter:

    QSH

  3. Run the cd shell command, specifying the fully qualified path to the installation kit directory. For example: 
    cd /MySametimePackages/DatabaseScripts/SystemConsole
  4. If the "SSC" and "POLICY" schemas doe not already exist, run the following shell command to create the required schemas and tables: 
    ./createSCDb.sh
  5. When the script completes, press F3 to exit QSH.
  6. Verify that the "SSC" and "POLICY" schemas exist.