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?
Unable to delete project in adminsitrator
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 120
- Joined: Thu Oct 28, 2004 4:24 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.)
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.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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,
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,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.