Creating the Sametime Proxy Server database schemas and tables on IBM i

Run the createProxyDb.sh script to create the database schema for the IBM® Sametime® Proxy Server on IBM i.

About this task

On the IBM i system where you will install the Sametime Proxy Server, follow these steps to create the database schema and tables:

Procedure

  1. Log on to the server with a user profile that has *ALLOBJ and *SECADM special authorities.

    These authorities are required to create the database schemas.

  2. Find the software packages you need to download.
  3. Download the packages.
  4. Extract all downloaded packages.
  5. From an IBM i command line, run this command to start the QShell Interpreter:

    QSH

  6. Run the cd shell command, specifying the fully qualified path to the installation kit directory.

    For example,

    cd /ST_ProxyServer_Package/SametimeProxyServer/DatabaseScripts/ProxyServer

  7. If the "STPROXY" schema does not exist on the system, run the following shell command to create the required database schemas and tables:
    ./createProxyDb.sh
  8. When the script completes, press F3 to exit QSH.
  9. Verify that the "STPROXY" schema exists.