Removing unused staff query results, using administrative commands

Use the administrative commands to remove unused staff query results from the database.

Before you begin

Before you begin this procedure, the following conditions must be met:
  • The application server, through which unused staff queries are to be deleted, must be running. That is, the -conntype none option of wsadmin cannot be used, because a server connection is required.
  • When security is enabled, you must have operator authority.

Why and when to perform this task

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

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

Steps for this task

  1. Change to the Business Process Choreographer subdirectory where the administration scripts are located.
    On Windows® systems, enter:
    cd install_root\ProcessChoreographer\admin
    On Linux® and UNIX® systems, enter:
    cd install_root/ProcessChoreographer/admin
  2. Remove the unused staff lists.

    On Windows systems, enter one of the following commands. The differences between the commands are emphasized:

    install_root\bin\wsadmin –lang jython -f cleanupUnusedStaffQueryInstances.py 
                             -server serverName
                             [-profileName profileName]
    
    
    install_root\bin\wsadmin –lang jython -f cleanupUnusedStaffQueryInstances.py 
                             -node nodeName
                             -server serverName
                             [-profileName profileName]
    
    install_root\bin\wsadmin –lang jython -f cleanupUnusedStaffQueryInstances.py 
                             -cluster clusterName
                             [-profileName profileName]

    On UNIX and Linux systems, enter one of the following commands. The differences between the commands are emphasized:

    install_root/bin/wsadmin.sh –lang jython -f cleanupUnusedStaffQueryInstances.py 
                             -server serverName
                             [-profileName profileName]
    
    install_root/bin/wsadmin.sh –lang jython -f cleanupUnusedStaffQueryInstances.py 
                             -node nodeName 
                             -server serverName
                             [-profileName profileName]
    
    install_root/bin/wsadmin.sh –lang jython -f cleanupUnusedStaffQueryInstances.py 
                             -cluster clusterName
                             [-profileName profileName]

    Where:

    cluster clusterName
    The name of the cluster. Required if the business process container is configured for a WebSphere® cluster.
    node nodeName
    Optional when specifying the server name. This name identifies the node. The default is the local node.
    server serverName
    The name of the server. Required if the cluster name is not specified.
    profileName profileName
    The name of a user-defined profile. Specify this option if you are not working with the default profile.

Result

The number of entries deleted from the database is displayed.

Example

Note: The jacl version of the cleanup unused staff query script, cleanupUnusedStaffQueryInstances.jacl, is deprecated. It is available in the util subdirectory of the ProcessChoreographer directory and it takes the same parameters as described here, but the –lang jython option must be omitted.

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)