Removing business rule and selector data from the repository

When you uninstall an application that uses business rules or selectors, the server does not remove these artifacts from the repository. This task removes unneeded business rule and selector artifacts from the repository.

Before you begin

Make sure that you uninstall all copies of applications that use the business rules or selectors to be removed from all servers.

Why and when to perform this task

When you install an application containing business rule or selector artifacts, the server stores these artifacts in database tables so that you can dynamically update them without changing the application. This also allows other servers to share these artifacts. When you uninstall an application, the server does not automatically remove these artifacts from the database tables because the application may still be installed and running on another server. Deleting the artifacts from the database causes the other running copies of the application to fail when they try to use business rules or selectors.

To delete the unused artifacts from the database, you must do so manually after you uninstall all applications that use them. Remove artifacts using the tools supplied by the database platform of your repository.

Steps for this task

  1. Locate the database.

    Locating the database depends on the database platform.

    Database platform Location
    Cloudscapeâ„¢ WASHOME\cloudscape\ / databases\RepositoryDB
    Other databases Depends on the location configured during installation and profile creation of the server. For example, if you configured the server automatically and selected the default database name, the name of the database is WPRCSDB.
  2. Locate the following database tables from which you will delete rows:
    BYTESTORE
    The main table that contains the business rule and selector artifacts
    BYTESTOREOVERFLOW
    The overflow table for the main table
    APPTIMESTAMP
    The installed applications that contain business rule and selector artifacts
  3. Delete the artifacts for an application.

    Using the tools for your database platform, follow these steps to delete all business rule and selector artifacts for a given application:

    1. Find all of the rows in the BYTESTORE table where the APPNAME column is the same as the name of the application.
    2. Record the values of the primary key columns for all the rows found. The primary key columns for the BYTESTORE table are ARTIFACTTNS, ARTIFACTNAME, and ARTIFACTTYPE.
    3. Delete the rows found in step 3.a from the BYTESTORE table.
    4. For each set of primary key values recorded in step 3.b, find rows in the BYTESTOREOVERFLOW table that have the same values in the corresponding columns.
      Note: For a given set of primary key values, there may be zero, one, or more than one row in the BYTESTOREOVERFLOW table.
    5. Delete rows found in step 3.d from the BYTESTOREOVERFLOW table.
    6. Delete the row in the APPTIMESTAMP table where the APPNAME column equals the name of the application.

Result

You have removed the unneeded business rules and selector artifacts from the database tables.

Terms of use |

Last updated: Tue Feb 21 17:19:15 2006

(c) Copyright IBM Corporation 2005.
This information center is powered by Eclipse technology (http://www.eclipse.org)