Undeploying composite and supplemental query tables

Use an administrative script to remove composite and supplemental query tables in Business Process Choreographer.

Before you begin

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.
Ensure that no applications are running that reference a query table that is to be undeployed. If a supplemental query table is undeployed, it must not be referenced, as attached query table, by any composite query table.

About this task

Complete the following steps to undeploy composite and supplemental query tables in Business Process Choreographer.

Procedure

Change to the Business Process Choreographer subdirectory where the administrative script is located. Enter the following command:
```
smpe_root/ProcessChoreographer/admin
```
Enter the following command:
```
cd install_root/ProcessChoreographer/admin
```
Enter the following command:
```
cd install_root\ProcessChoreographer\admin
```
Undeploy the query table: Enter the following command:
```
install_root/bin/wsadmin.sh –f manageQueryTable.py
       [ ([-node nodeName] -server serverName) | (-cluster clusterName) ]
       -undeploy queryTableName
```
Enter the following command:
```
install_root/bin/wsadmin.sh –f manageQueryTable.py
       [ ([-node nodeName] -server serverName) | (-cluster clusterName) ]
       -undeploy queryTableName
```
Enter the following command:
```
install_root\bin\wsadmin –f manageQueryTable.py
       [ ([-node nodeName] -server serverName) | (-cluster clusterName) ]
       -undeploy queryTableName
```
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.

-undeploy queryTableName

The name of the query table. Use this option to undeploy a query table.

Example

For example: This topic applies only to the z/OS platform

Enter the following command: This topic applies only to the z/OS platform

wsadmin.sh –f manageQueryTable.py –server server1 –undeploy COMPANY.SAMPLE

This topic applies only to the Distributed platforms For Linux operating system For UNIX operating system Enter the following command:

wsadmin.sh –f manageQueryTable.py –server server1 –undeploy COMPANY.SAMPLE

This topic applies only to the Distributed platforms For Windows operating system Enter the following command:

wsadmin –f manageQueryTable.py –server server1 –undeploy COMPANY.SAMPLE