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
- 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. |
- 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
- 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:
- Find all of the rows in the BYTESTORE
table where the APPNAME column is the same as the name
of the application.
- 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.
- Delete the rows found in step 3.a from the BYTESTORE table.
- 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.
- Delete rows found in step 3.d from the BYTESTOREOVERFLOW table.
- 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.