Removing unused staff queries, using administrative commands

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

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

Terms of use | | Broken links

Last updated: Tue Dec 06 04:14:42 2005

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