DSXchange

Hi,

My Unix project directory has been deleted.

i am trying to delete the project name using the administrator .

I am getting an error message

Direcotry you are connecting to either is not a UV account or does not exists (39125)

How do I delete this project in datastage?

Well I assume you do project backups on a frequent basis ??
Restore the project.

Then if you really don't want it delete it the right way.

Hi,

I want to recreate the project with the same name as the back up file is corrupted.

How do i do as administrator says that project already exists.
Thanks
Ketfos

You might start by searching the forums here for UVFIXFILE or fixtool.

Those utilities probably won't solve this one. Your first task is to determine why the Administrator is reporting that the project still exists, and to tell us who deleted it incompletely and using which method.

If there is an entry for the project in the UV.ACCOUNT table, this entry can be deleted.
If there is an entry for the project in the UV_SCHEMA table, then the VERIFY.SQL tool needs to be used to correct this. (You will not be able to use DELETE with this table. It's protected.)

Ah... you so right. That was the one that I was trying to remember but my searching only turned up the other two.

From the description, it sounds like there will also be data left in XMETA as well, which is probably where Administrator is now getting it's list of projects from. Those will need to be removed as well as any lingering data in UV.

The OP should contact their official support provider for the correct instructions for cleaning this up. For 8.0 and 8.1 it's a multi-step process. I think it's improved for 8.5, but don't know the specifics.

Regards,