Hi,
I can see project from Unix command line in Projects path but not via Administrator.
Is there any way we can delete the project from Unix Command line? if so what is the command. please share.
Thx
Delete Project from Command line
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DO NOT EVEN CONTEMPLATE DOING THAT
The project directory is only a part of the picture. It is also a database schema so there are system tables that refer to it.
What you really need to do will depend on what's preventing the Administrator from finding the project - probably one of the system tables UV.ACCOUNT or UV_SCHEMA. These are repaired differently. Get into TCL In the UV account execute the following commands.
Which one fails to mention your project, or refers to a wrong pathname?
The project directory is only a part of the picture. It is also a database schema so there are system tables that refer to it.
What you really need to do will depend on what's preventing the Administrator from finding the project - probably one of the system tables UV.ACCOUNT or UV_SCHEMA. These are repaired differently. Get into TCL In the UV account execute the following commands.
Code: Select all
SELECT * FROM UV.ACCOUNT;
SELECT * FROM UV_SCHEMA;
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.
with those 2 SQL statements i can see the project which i am looking for and it is in correct project path.
here is what happened - I have a project called 'Project_A' on system-N and I created a Project_B on System-N and scp'ed all the components from other system - System-O's 'Project_A' to System-N's 'Project_B' ( which i created newly) and SCP went fine. Then using Admin i deleted 'Project_B' on System-N, but some how via Administrator on System-N i can't see both Project-A and Project-B but from $DSHOME I can see Project-B but not the Project-A.
With the sql commands you mentioned - when i ran them i can see only 'Project-A' (which should be as i did not deleted that project).
When I log to Admin i am getting following message and letting me in Admin but i am not able to see Project-A and Project-B (which i deleted).
suggest me how to fix this issue and bring Project-A successfully back.
Thx
here is what happened - I have a project called 'Project_A' on system-N and I created a Project_B on System-N and scp'ed all the components from other system - System-O's 'Project_A' to System-N's 'Project_B' ( which i created newly) and SCP went fine. Then using Admin i deleted 'Project_B' on System-N, but some how via Administrator on System-N i can't see both Project-A and Project-B but from $DSHOME I can see Project-B but not the Project-A.
With the sql commands you mentioned - when i ran them i can see only 'Project-A' (which should be as i did not deleted that project).
When I log to Admin i am getting following message and letting me in Admin but i am not able to see Project-A and Project-B (which i deleted).
Code: Select all
Failed to connect to host: zzzz1122, project: Project-A
( The directory you are connecting to either is not a UV account or does not exist (39125))
Thx
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's a non-trivial process. The way that you set up the project (via copy commands) is so totally wrong. You may indeed be better off to delete the project directory then to clean up the system tables.
The basics of cleaning up after deleting a project are described in this paper but there is likely to be more needed, not least re-indexing the project.
You may be better off hiring a competent consultant to effect this recovery for you if you need to recover the project.
The basics of cleaning up after deleting a project are described in this paper but there is likely to be more needed, not least re-indexing the project.
You may be better off hiring a competent consultant to effect this recovery for you if you need to recover the project.
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.
Try to see which is giving you the problem.
See what errors you getting.
Code: Select all
VERIFY.SQL SCHEMA /pathname/Project_A
VERIFY.SQL SCHEMA /pathname/Project_B
VERIFY.SQL SCHEMA Project_A
VERIFY.SQL SCHEMA Project_B
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'