Purging Orchestration Workflow Data Manually

This topic describes how you can delete SBM Orchestration Engine runtime data interactively, on a one-time basis. In this procedure, you must run the tool manually each time you want to purge data from the tables.

The required parameters for manual mode are already supplied with default values, and do not need to be passed at the command line. For descriptions of the parameters, see Purge Parameters. For information about changing the default parameters and behavior, see Changing Default Parameters and Behavior.

Note: You can hard code parameters in the purge.bat file as described in Changing Default Parameters and Behavior; however, this is not recommended because the parameters will be used in all purges, including automatic purges.
Tip: You can also purge data automatically, which could be more convenient. See Purging Orchestration Workflow Data Automatically for instructions.

To purge SBM Orchestration Engine runtime data manually:

  1. In the installationDirectory\Serena\SBM\Common\jboss405\bin directory, type purge.bat.
  2. When prompted, provide the username and password for database access.
    Note: You can pass the dbUsername and dbPassword parameters at the command line to suppress these prompts. For example, installationDirectory\Serena\SBM\Common\Common\jboss405\bin purge.bat -dbUsername joe -dbPassword joe432. (The dbUsername "joe" and the dbPassword "joe432" are examples and should be replaced by an actual username and password.)
  3. The tool displays the following:
    • The number of rows of data from orchestration workflows that executed
    • The age of the data, in days
    • The maximum number of rows that can be deleted
  4. The tool informs you how many rows will be deleted permanently. When prompted, type y to confirm, or n to change the number of days.
  5. If you typed y, the data is purged. The tool informs you when the purge is complete, and tells you how many rows remain after the purge.