This topic applies only to the IBM Business Automation Workflow Advanced configuration.

cleanupUnusedStaffQueryInstances.py administrative script

Edit online
Draft comment:
This topic only applies to BAW, and is located in the BAW repository. Last updated on 2025-03-13 12:15
Use the cleanupUnusedStaffQueryInstances.py administrative script to remove from the database unused results from people queries.

Business Process Choreographer maintains lists of user names in the runtime database for people queries that have been evaluated. Although the BPEL process instances and human tasks that used the people queries have finished, the lists of user names are maintained in the database until the corresponding process application is undeployed.

If the size of the database is affecting performance, you can remove the unused lists of people that are cached in the database tables.

Prerequisites

The following conditions must be met:
  • Run the script in the connected mode, that is, do not use the wsadmin -conntype none option.
  • At least one cluster member must be running.
  • Include the wsadmin -user and -password options to specify a user ID that has operator authority.
  • If you are not working with the default profile, use the wsadmin -profileName profile option to specify the profile.

Location

The cleanupUnusedStaffQueryInstances.py administrative script is in the Business Process Choreographer admin directory.
For Windows operating systeminstall_root\ProcessChoreographer\admin
For Linux operating systemFor UNIX operating systeminstall_root/ProcessChoreographer/admin

Syntax

For Linux operating systemFor UNIX operating systeminstall_root/bin/wsadmin.sh 
For Windows operating systeminstall_root\bin\wsadmin

-f cleanupUnusedStaffQueryInstances.py 
  -cluster cluster_name 
    [-cleanupSharedWorkItems]

Parameters

-f
This parameter specifies the script file to run.
-cluster clusterName
The name of the cluster where Business Process Choreographer is configured. In a multicluster setup, you must specify the application cluster because that is where Business Process Choreographer is configured.
-cleanupSharedWorkItems
Specify this optional parameter if you also want the script to delete unused shared work items.
-server serverName
The name of the server where Business Process Choreographer is configured. Required if the cluster name is not specified.

If you notice any performance issues when you use the cleanupUnusedStaffQueryInstances.py script, see Using cleanupUnusedStaffQueryInstances.py results in delayed deletion of unused query results.