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

Retrieving a list of query tables

Use an administrative script to get a list of query tables that are available in Business Process Choreographer. You can list predefined, supplemental, and composite query tables.

Before you begin this procedure, the following conditions must be met:

• Run the script in connected mode, that is, the application server must be running. Do not use the wsadmin -conntype none option.

• 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 administrator or deployer authority, include the wsadmin -user and -password options to specify a user ID that has administrator or deployer authority.
• If you are not working with the default profile, use the wsadmin -profileName profile option to specify the profile.

Complete the following steps to get a list of query tables in Business Process Choreographer.

Procedure

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

    smpe_root/ProcessChoreographer/admin

   

   • 

     In the directory:

     INSTALL_ROOT/ProcessChoreographer/admin

   • In the directory:

     INSTALL_ROOT\ProcessChoreographer\admin

2. To list query tables in the command prompt window.

    INSTALL_ROOT/bin/wsadmin.sh –f manageQueryTable.py
          [ ([-node  nodeName] -server  serverName) | (-cluster  clusterName) ]
          -query names 
          -kind (composite | predefined | supplemental)

   

    INSTALL_ROOT/bin/wsadmin.sh –f manageQueryTable.py
          [ ([-node  nodeName] -server  serverName) | (-cluster  clusterName) ]
          -query names 
          -kind (composite | predefined | supplemental)

   

    INSTALL_ROOT\bin\wsadmin –f manageQueryTable.py
          [ ([-node  nodeName] -server  serverName) | (-cluster  clusterName) ]
          -query names 
          -kind (composite | predefined | supplemental)

   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.

   -kind (composite | predefined | supplemental)

   The type of the query table to be listed whether composite, predefined, or supplemental. If there are no query tables of the selected kind, none is returned.

Example

For example.

wsadmin.sh –f manageQueryTable.py –server server1 
           –query names –kind composite

wsadmin.sh –f manageQueryTable.py –server server1 
           –query names –kind composite

wsadmin –f manageQueryTable.py –server server1 
        –query names –kind composite

Administer query tables

Related tasks:
Update composite and supplemental query tables
Retrieving the XML definitions of query tables
Deploying composite and supplemental query tables
Undeploying composite and supplemental query tables