| Installing Upgrading Designing Configuring Deploying Monitoring Administering Troubleshooting Reference JBI Components | |
| Close Print View | |
| Administering: Purging and Archiving Sun BPM Data |
|
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
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
Working With the Master Index Data Manager
Maintaining Sun Master Indexes
Scripts for purging and archiving Sun BPM data are included with the compressed database files that you can download from Enterprise Designer (see Downloading the Compressed Script Files). The purge scripts delete older records (instances only) from the database tables based on the specified number of days, Business Process name, or application name. The archive scripts copy the history records into tables ending with _hist based on the specified number of days, Business Process name, or application name. Only records with a status of COMPLETE, ERROR, TERMINATED, ERROR_ON_RECOVER are purged or archived.
In the instructions in this section, the following arguments are used:
user is the database username.
password is the database user password.
server is the name of the machine on which the database resides.
database is the database or TNS name.