A project consists of three things, a directory containing the Repository objects and various other files, an entry in the UV.ACCOUNT hashed file, and various entries in the system tables for DataStage.
Remove the project directory and all its contents.
Remove the entry from the UV.ACCOUNT file. Get into the DataStage environment in the DataStage Engine directory and execute (very carefully)
Code: Select all
DELETE FROM UV.ACCOUNT WHERE @ID = '<<ProjectName>>';
While still in the DataStage environment clean up the system tables with the following command
Code: Select all
VERIFY.SQL PATHNAME <<pathname_of_project_directory>> FIX
(Note that without FIX is perfectly safe, and will report the intended repair actions. You can not run this command with the FIX keyword unless logged in with DBA privileges.)
This method ceases to be correct with effect from version 8.0.