Installing Upgrading Designing Configuring Deploying Monitoring Administering Troubleshooting Reference JBI Components
Close Print View
Administering: Installing the Purge and Archive Database Components
 

Classic Java CAPS

Managing Java CAPS Users

Using LDAP with Java CAPS

Administering the Sun Business Process Manager Database

Creating the Monitoring and Recovery Database

Creating the Database Instance

Running the Scripts in Enterprise Designer

Running the Database Scripts from a Local Directory

Running Database Scripts Automatically

To run the scripts automatically

Purging and Archiving Sun BPM Data

Installing the Purge and Archive Database Components

Archiving and Purging by Retention Days

Archiving and Purging by Business Process Name

Archiving and Purging by Application Name

Using the Sun Business Process Manager Worklist Manager for User Activities

Maintaining Sun Master Indexes (Repository)

Working With the EDM for Sun Master Patient Index

Working With the EDM for Sun Master Index

Java EE Based Components

Working With the Master Index Data Manager

Maintaining Sun Master Indexes

Analyzing and Cleansing Data for Sun Master Index

Loading the Initial Data Set for a Sun Master Index

Installing the Purge and Archive Database Components

Before you can run the purge and archive scripts you need to install the stored procedures and tables to support the processes. Make sure you have created the database and downloaded the compressed database scripts as described in Downloading the Compressed Script Files before beginning this procedure.

To install the purge and archive database components
  1. Open a command window and navigate to the directory where you downloaded the scripts.
  2. Do one of the following:
    • For Oracle and DB2 databases, enter the following command:

      install_arch_and_purge_scripts user password database

    • For Sybase and SQL Server databases, enter the following command:

      install_arch_and_purge_scripts user password server database