WebSphere brand IBM WebSphere Presence Server, Version 7.0

Creating the Service Integration Bus (SIBus) database for DB2

You can optionally configure a SIBus database before installing Presence Server.

Before you begin
Before you begin, the following software should be installed:
  • IBM® DB2® Enterprise Server Edition, version 9.5 FixPak 1
  1. Log in to the DB2 server as a database administrator.
  2. Create a directory that has write and execute permission, for example DB_dir.
  3. Copy the installation .tar file, IBMPresenceServerDbPackage_7.0.tar, from the installation medium to the new directory.
  4. Switch to the new directory.
  5. Unpack the installation .tar file using the following command:
    tar -xvf IBMPresenceServerDbPackage_7.0.tar
  6. Change (cd) to the following directory: was_root/installableApps/presence/scripts/dbScripts/SIBus.
  7. Verify that the following files exist in /SIBus:
    • createDB2SIBus.sh
    • dropDB2SIBusSchemas.sh
  8. Run the following command to ensure that the database configuration script will run properly:
    • chmod 755 createDB2SIBus.sh
  9. Issue the following command to create the database:
    ./createDB2SIBus.sh db_name database_administrator_ID database_administrator_pw 
    where:
    • db_name is the name of the SIBus database, for example PSSIBUS
    • database_administrator_ID is the authorized user for the database, for example db2inst
    • database_administrator_pw is the password for the authorized user
  10. Verify that the database was created properly by typing the following command:
    • db2 connect to db_name user database_administrator_ID
    For example:
    db2 connect to PSSIBUS user db2inst
    If the script ran properly, the following results display:
    Database Connection Information
    
     Database server        = DB2/LINUX 9.5.1
     SQL authorization ID   = database_administrator_ID
     Local database alias   = db_name
Results
Note: If errors occur when you run the database preparation script, refer to the topic Troubleshooting the database script.
What to do next
The required DB2 database tables will be created for you when you run the Presence Server interactive installation or silent installation.



Terms of use
(C) Copyright IBM Corporation 2009. All Rights Reserved.