Archiving and Purging by Application Name

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

• purge_by_appname.cmd - Purges the history data by the specified application name.

• arch_by_appname.cmd - Archives the history data by the specified application name.

To purge records based on application 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_appname user password database name

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

     purge_by_appname user password server database name

     Where name is the application name to purge. For example, if you specify Application1, then all instances of Application1 data are purged.

To archive records based on application 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_appname user password database name

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

     arch_by_appname user password server database name

     Where days is the application name to archive. For example, if you specify Application1, then all instances of Application1 data are archived.