How do you manually delete an IBM InfoSphere DataStage project

Answer

If a project is partially created, deleted, or inaccessible, you might have to delete the project manually.

To perform this procedure, you must use the DStageWrapper script.
The DStageWrapper script is a utility that can be obtained from the Information Server Support.

The steps in this technote are for Information Server 8.0.1 or 8.1. If you are using Information Server 8.5 or 8.7, refer instead to the following presentation:
How to manually delete a DataStage project

The steps to remove a project manually from 8.0.1 or 8.1 are as follows:
1. Remove the project from the InfoSphere DataStage engine.

a. In a command window, login with the DataStage Administrator id (i.e. dsadm) and make a backup of the project directory by changing its name:
1. cd /opt/IBM/InformationServer/Server/Projects
2. mv MyProj MyProj.save
where MyProj is the directory of the project that you want to delete.
b. Change to the $DSHOME directory and connect to the InfoSphere DataStage engine.
1. cd /opt/IBM/InformationServer/Server/DSEngine
2. . ./dsenv
3. bin/uvsh
The “>” prompt of the InfoSphere DataStage engine is displayed.
c. In the InfoSphere DataStage engine, remove the project entry from UV.ACCOUNT.
1. > DELETE UV.ACCOUNT MyProj
2. > VERIFY.SQL SCHEMA MyProj FIX
3. > QUIT

a. List the projects in the metadata repository and see if the project still exists. Enter the following command:
For 8.1:
DStageWrapper.sh -user username -password password -domain domainname -query "select x.Name, x.HostName from x in DSProject"

Where:
Username is the account of a user with the Suite Administrator role.
Domainname is the server:port for the host name and port of the computer where IBM WebSphere Application Server is installed.

An example might be:
DStageWrapper.sh -user johndoe -password abcdefg -domain WAS_server:9080 -query "select x.Name, x.HostName from x in DSProject"

For 8.0.1:
DStageWrapper.sh -query "select x.Name, x.HostName from x in DSProject"

With either command, the project names and server names are listed. If the project that you want to remove is listed, perform the next step. Otherwise, no further steps are needed.

b. Delete the project.

In the following command, type the server and project names exactly as they are displayed in the project list output. The names that you type must be in the same case as the names in the project list output.

For 8.1:
DStageWrapper.sh -user username -password password -domain domainname –deleteproject server_name project_name

Use the same values of username and domainname as in the previous step.

For 8.0.1:
DStageWrapper.sh -deleteproject server_name project_name