Project deleted but still exists
Moderators: chulett, rschirm, roy
Project deleted but still exists
hi,
Project deleted from administrator, but still exists in datastage project path on Unix.
pls advise.
Project deleted from administrator, but still exists in datastage project path on Unix.
pls advise.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Was the Administrator client been closed before the process completion?
As mentioned, this might cause the partial deletion.
Check the presence of the project record in both UV_SCHEMA and as well as UV.ACCOUNT.
If found you need to delete those entry. Once it is done, you can carfully Delete the unix Project folder, if found again.
But before that, take a backup of all the available project at project level as well as Unix level.
As mentioned, this might cause the partial deletion.
Check the presence of the project record in both UV_SCHEMA and as well as UV.ACCOUNT.
Code: Select all
SELECT * FROM UV_SCHEMA WHERE SCHEMA_NAME = 'project'
SELECT * FROM UV.ACCOUNT WHERE @ID = 'project'
But before that, take a backup of all the available project at project level as well as Unix level.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Bad advice, not least because you can not simply delete entries from UV_SCHEMA and secondarily because a semi-colon terminator is required for each DataStage/SQL statement. And, third, UV.ACCOUNT is not accessible, by default, from the Administrator client without creating a pointer to it. Checking UV_SCHEMA will suffice for determining how far along the deletion process got.
We await a response from dspxguy.
We await a response from dspxguy.
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.
Hi Ray,
May I know what do you refer as "UV.ACCOUNT is not accessible, by default, from the Administrator client without creating a pointer to it."?
What kind of pointer should be created and where?
I dont remember creating any pointer as such.
May I know what do you refer as "UV.ACCOUNT is not accessible, by default, from the Administrator client without creating a pointer to it."?
What kind of pointer should be created and where?
I dont remember creating any pointer as such.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is no pointer to UV.ACCOUNT in a DataStage project's VOC, as installed.
It may have been created there explicitly (for example using SETFILE) or implicitly (for example by using certain options of DS.TOOLS), but it's not there by default.
It may have been created there explicitly (for example using SETFILE) or implicitly (for example by using certain options of DS.TOOLS), but it's not there by default.
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.
Gentlemen,
I ran these commands from UV prompt
didnt find the deleted project there, i dont even see it in the project down list in the client components. but it is still in Unix $DSHOME ../Projects/
I ran these commands from UV prompt
Code: Select all
SELECT * FROM UV.ACCOUNT;
SELECT * FROM UV_SCHEMA;
Always use Administrator. Your project couldn't be deleted because there may have been a permissions issue with just one single object within the directory. Folks who let their jobs write files to the project location run the risk of leaving behind files that can't be removed. You've probably got some files that prevented the total remove of the project. If it's gone from the project drop down lists and doesn't show up in the UV.ACCOUNT, it's up to you if you do a physical unix-level removal. If it's not using up much space leave it alone, otherwise, remove any user files within to reclaim space. If it's still an issue, then you can consider an "rm" to get rid of it.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
May be implicitly! We never created a explicit pointer so far in any of my previous projects. Still worked.ray.wurlod wrote:There is no pointer to UV.ACCOUNT in a DataStage project's VOC, as installed.
It may have been created there explicitly (for example using SETFILE) or implicitly (for example by using certain options of DS.TOOLS), but it's not there by default.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'