Use the administrative commands to remove unused staff queries
from the database.
Before you begin
Before you begin this procedure, the following conditions must
be met:
- The user ID that you are using must have administrative rights.
- 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 processes instances that used these 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 utilities directory
where the scripts are located.
On Windows
® systems,
enter:
cd install_root\ProcessChoreographer\util
On UNIX
® and Linux
® systems, enter:
cd install_root/ProcessChoreographer/util
- 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 -f cleanupUnusedStaffQueryInstances.jacl
-server serverName
[-profileName profileName]
install_root\bin\wsadmin -f cleanupUnusedStaffQueryInstances.jacl
-node nodeName
-server serverName
[-profileName profileName]
install_root\bin\wsadmin -f cleanupUnusedStaffQueryInstances.jacl
-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 -f cleanupUnusedStaffQueryInstances.jacl
-server serverName
[-profileName profileName]
install_root/bin/wsadmin.sh -f cleanupUnusedStaffQueryInstances.jacl
-node nodeName
-server serverName
[-profileName profileName]
install_root/bin/wsadmin.sh -f cleanupUnusedStaffQueryInstances.jacl
-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.