WebSphere brand IBM WebSphere XML Document Management Server, Version 7.0

Creating the DB2 database and database tables for the XDMS enablers

Create the DB2® database for the enabler applications that you plan to deploy.

Before you begin
Before you begin, you must have completed the following task:
  • Installed and started IBM® DB2 Enterprise Server Edition, 9.5 FixPak 1
  • Installed the DB2 client or copied the DB2 client files to all WebSphere servers
About this task

Copy IBMXdmsDbPackage_7.0.0.tar from the installation media and untar it on your system. Then, switch to the XDMS directory of the IBMXdmsDbPackage_7.0.0.tar. A database-creation script is provided for each enabler.

The scripts are named as follows:
  • Shared List XDMS: IBMSharedListXdmsDb2.sh
  • Presence Rules XDMS: IBMPresenceRulesXdmsDb2.sh
  • Shared Profile XDMS: IBMSharedProfileXdmsDb2.sh
  • Shared Policy XDMS: IBMSharedPolicyXdmsDb2.sh
  • Shared Group XDMS: IBMSharedGroupXdmsDb2.sh
  • Shared Enablers XDMS: IBMSharedEnablersXdmsDb2.sh

Create only the databases that you need.

  1. Copy the scripts from one of the WebSphere® Application Server nodes to a location on the database server that can be accessed by the instance owner.
  2. Log in to DB2 as the DB2 instance owner, for example db2inst1.
  3. Start the DB2 instance.
  4. Make the scripts executable by executing the following command for each script that you plan to use: chmod 755 script_name.sh
  5. Create the databases and database tables by running the following command for each enabler that you plan to deploy:
    • ./script_name.sh db_name db_user db_password
    For example:
    • ./IBMSharedListXdmsDb2.sh XdmsSL db2inst1 password
  6. Verify that the XDMS databases were created properly by executing the following command:
    • db2 connect to db_name user db_user using db_password
    For example:
    • db2 connect to XdmsSL user db2inst1 using password
    You should see results that are similar to the following:
    Database Connection Information
    
     Database server        = DB2/LINUX 9.5.1
     SQL authorization ID   = DB2INST1
     Local database alias   = db_name
  7. Verify that all tables were properly created by executing the db2 list tables command.

    The display should show one table for each AUID represented by the enablers that you plan to deploy. AUIDs for the enablers are listed under the topic XDMS enablers.

  8. Retain the following information. You will need it when you install and configure each enabler and when you connect to the databases for the enablers.
    • Database name
    • Connection port
    • DB2 instance server hostname
    • DB2 instance userid and password



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