WebSphere brand IBM WebSphere Presence Server, Version 7.0

Cleaning Oracle database tables

Clear the contents of Oracle database tables whenever you reinstall Presence Server. Optionally, you can also perform this task when uninstalling Presence Server.

Before you begin
Verify that the following file exists n the database server in was_root/installableApps/presence/scripts/dbScripts/presence:
  • DeleteContentOra.ddl
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
About this task
The following command should be run for each database you have created for Presence Server.
  1. Stop all application servers in the cluster on which Presence Server is running.
  2. Log in to the Oracle server as a database administrator.
  3. Switch to the following directory: was_root/installableApps/presence/scripts/dbScripts/presence.
  4. Run the following command to clean the contents of the Presence Server database tables:
    • ./RunConfigOracle.sh
    Supply values for the parameters as follows:
    dbName
    The name of the database, for example PSDB.
    dbUser
    User ID for the authorized user (the ID with which you are logged in), for example dbadmin.
    dbUserPW
    Password for the authorized user.
    ddlFile
    Path to the data definition language (ddl) file used to clean the database tables: DeleteContentOracle.dll.
Example

For example:

./RunConfigOracle.sh dbName=PSDB dbUser=dbadmin dbUserPW=password
ddlFile=DeleteContentOracle.dll
Note: Enter the entire command on one line.
What to do next
When the script completes, the following database tables are cleaned of their contents:



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