IBM BPM, V8.0.1, All platforms > Administer the IT infrastructure > Administer Business Process Choreographer > Use scripts to administer Business Process Choreographer > Delete Business Process Choreographer objects

Remove unused people query results, using administrative scripts

Use an administrative script to remove unused people query results from the database.

The following conditions must be met:

• Run the script in the connected mode, that is, the application server must be running.

• If Business Process Choreographer is configured on a cluster, then at least one cluster member must be running.

• If WebSphere administrative security is enabled, and your user ID does not have operator authority, 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.

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.

Procedure

1. Change to the Business Process Choreographer subdirectory where the administrative script is located.
   

   cd  INSTALL_ROOT/ProcessChoreographer/admin

   cd INSTALL_ROOT/ProcessChoreographer/admin

   cd INSTALL_ROOT\ProcessChoreographer\admin

2. Remove the unused lists of people.
   

    INSTALL_ROOT/bin/wsadmin.sh  -f cleanupUnusedStaffQueryInstances.py 
     ( [-node  node_name] -server  server_name) | (-cluster  cluster_name )
       [-cleanupSharedWorkItems]

   

    INSTALL_ROOT/bin/wsadmin.sh  -f cleanupUnusedStaffQueryInstances.py 
     ( [-node  node_name] -server  server_name) | (-cluster  cluster_name )
       [-cleanupSharedWorkItems]

   

    INSTALL_ROOT\bin\wsadmin -f cleanupUnusedStaffQueryInstances.py 
     ( [-node  node_name] -server  server_name) | (-cluster  cluster_name )
       [-cleanupSharedWorkItems]

   Where:

   -node nodeName

   The name of the node where Business Process Choreographer is configured. This is optional when specifying the server name. The default is the local node.

   -server serverName

   The name of the server where Business Process Choreographer is configured. This is required if a cluster is not specified.

   -cluster clusterName

   The name of the cluster where Business Process Choreographer is configured. This is required if Business Process Choreographer is configured on a cluster.

   -cleanupSharedWorkItems

   Specify this optional parameter if you also want the script to delete unused shared work items.

Results

The number of entries deleted from the database is displayed.

Delete Business Process Choreographer objects