WebSphere brand IBM WebSphere XML Document Management Server, Version 7.0

Creating Oracle database tables for the XDMS enablers

You must create Oracle databases and database tables for the enabler applications that you plan to deploy.

Before you begin
Before you begin, the following software should be installed:
  • Oracle Database, version 11.1.0.7
After you have unpacked the IBMXdmsDbPackage_7.0.0.tar file, follow the Oracle procedures to create databases for each of the following enablers that you plan to deploy:
  • Shared List XDMS
  • Presence Rules XDMS
  • Shared Profile XDMS
  • Shared Policy XDMS
  • Shared Group XDMS
  • Shared Enablers XDMS
About this task
A script for creating database tables is provided for each enabler. The scripts are located in the installableApps directory for the installed WebSphere® Application Server instance–for example, was_root/installableApps/xdms/scripts/dbScripts/xdms/.
Note: was_root is the installation root directory for WebSphere Application Server Network Deployment. By default, this directory is:
  • AIX /usr/IBM/WebSphere/AppServer
  • Linux /opt/IBM/WebSphere/AppServer
The scripts are named as follows:
  • Shared List XDMS: IBMSharedListXdmsOracle.sh
  • Presence Rules XDMS: IBMPresenceRulesXdmsOracle.sh
  • Shared Profile XDMS: IBMSharedProfileXdmsOracle.sh
  • Shared Policy XDMS: IBMSharedPolicyXdmsOracle.sh
  • Shared Group XDMS: IBMSharedGroupXdmsOracle.sh
  • Shared Enablers XDMS: IBMSharedEnablersXdmsOracle.sh

Create only the database tables 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 Oracle as the instance owner (system).
  3. Start the Oracle 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 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:
    • ./IBMSharedListXdmsOracle.sh XdmsSL db2inst1 password
  6. Use the Oracle SELECT command to verify that all tables were properly created. (Refer to the Oracle documentation for details about the command syntax.)

    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.

  7. 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
    • Oracle instance server hostname
    • Oracle instance user ID and password



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