Posted: Mon Jan 22, 2007 3:53 am
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)
While still in the DataStage environment clean up the system tables with the following command
(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.
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>>';
Code: Select all
VERIFY.SQL PATHNAME <<pathname_of_project_directory>> FIX
This method ceases to be correct with effect from version 8.0.