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
- 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
- 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.