Running the prune command

You run the prune command as part of the perfDWTool.

Remember: Run the prune command during a time when the server is not busy.

Before you begin

Before you run the prune command, complete the following tasks:

  • Ensure that you have installed or upgraded your Performance Data Warehouses to the latest version of IBM® BPM.
  • Start the Performance Data Warehouse. If you are running in a clustered environment, ensure that all servers in the cluster are running.
  • Create a backup of the performance database.
  • Go to the following directory: install_root\profiles\profile_name\bin.
    Remember: perfDWTool must be run from an active node in the support cluster.

Command syntax

Run the prune command by using the following syntax:

For UNIX operating systemFor Linux operating system
perfDWTool.sh -u user_name -p password -nodeName node_name  prune -daysOld number-of-days-old
For Windows operating system
perfDWTool.bat -u user_name -p password -nodeName node_name  prune -daysOld number-of-days-old

Where -daysOld indicates the age of the data that should be removed. The age is based on the current server time.

For example, suppose, at 4:00 p.m. on October 24, you use the prune command with the -daysOld parameter set to 2. All data that is older than October 22 at 4:00 p.m. is deleted.

Note the following information about the number-of-days-old argument:
  • It can contain only numeric characters.
  • It must be a value greater than 0.
  • If you enter 0 or a negative number, or if you include alphabetic or special characters, an error is returned.
Parent topic: Pruning data from the Performance Data Warehouse database