Administering: Archiving and Purging by Retention Days

Archiving and Purging by Retention Days

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

purge_by_days.cmd - Purges the history data by the specified number of days.
arch_by_days.cmd - Archives the history data by the specified number of days.

To purge records based on days

Open a command window and navigate to the directory where you downloaded the scripts.
Do one of the following:
- For Oracle and DB2 databases, enter the following command:
  
  purge_by_days user password database days
- For Sybase and SQL Server databases, enter the following command:
  
  purge_by_days user password server database days
Where days is the number of days to retain. For example, if you specify 4 days, then any records older than 4 days are purged.

To archive records based on days

Open a command window and navigate to the directory where you downloaded the scripts.
Do one of the following:
- For Oracle and DB2 databases, enter the following command:
  
  arch_by_days user password database days
- For Sybase and SQL Server databases, enter the following command:
  
  arch_by_days user password server database days
Where days is the number of days to retain. For example, if you specify 4 days, then any records older than 4 days are archived.

Installing Upgrading Designing Configuring Deploying Monitoring Administering Troubleshooting Reference JBI Components
Close Print View
Administering: Archiving and Purging by Retention Days