Archiving and Purging by Business Process Name

The following scripts are provided to archive and purge records based on the specified Business Process. The UNIX versions of these scripts have a .sh extension.

• purge_by_bpname.cmd - Purges the history data by the specified Business Process name.

• arch_by_bpname.cmd - Archives the history data by the specified Business Process name.

To purge records based on Business Process name

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:

     purge_by_bpname user password database name

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

     purge_by_bpname user password server database name

   Where name is the Business Process name to purge. For example, if you specify BusinessProcess1, then all instances of BusinessProcess1 are purged.

To archive records based on Business Process name

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:

     arch_by_bpname user password database name

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

     arch_by_bpname user password server database name

     Where name is the Business Process name to archive. For example, if you specify BusinessProcess1, then all instances of BusinessProcess1 are archived.