WebSphere brand IBM WebSphere XML Document Management Server, Version 7.0

Creating the usage records database and tables for Oracle

You must configure an Oracle usage records database. The crtsrvOra.sh script is provided for this purpose.

Before you begin
Before you begin, the following software should be installed:
  • Oracle Database, version 11.1.0.7
  1. Log in to the Oracle 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, IBMXdmsDbPackage_7.0.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 IBMXdmsDbPackage_7.0.0.tar
  6. Switch to the following directory: DB_dir/usageRecords.
  7. Delete the usage record table, if it has already been created.
  8. Run the crtsrvOra.sh script using the following command
    ./crtsrvOra.sh dbName dbAdmin dbAdminPW dbUser dbUserPW INITorDDLFile infoflag
    Use the following parameter values:
    Parameter Description Example value
    dbName Database name XDMS
    dbAdmin Database administrator ID SYSTEM
    dbAdminPW Database administrator password pw
    dbUser Database user ID xdmsuser
    dbUserPW Database user password pw
    INIT or DDLFile 'INIT' to initialize or path to DDL file UsageDbOra.ddl
    infoflag Display information flag TRUE
    Example:
    ./crtsrvOra.sh XDMSUR SYSTEM password xdmsuser password UsageDbORa.ddl TRUE
  9. After the script displays the input values, press Enter to continue.
  10. After the script completes, verify that the database tables were created properly by running a command similar to the following:
        select USAGERECORDS from user_tables
    If the script ran properly, the USAGERECORDS table is shown in the display.



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