job locked, clean up resources not working
Moderators: chulett, rschirm, roy
job locked, clean up resources not working
Hi,
I have a problem accessing a folder in the DataStage Director. The job in that folder seems to have been locked and I am not able to log out the process using the clean up resources option. I've even tried DS.TOOLS from the administrator, even that doesn't help . I cannot access any of the jobs in that particular folder where the locked job is located, the director just hangs when I try doing that. I can access the jobs from the designer but not the locked out job (gives out a message saying 'job being accessed by another user'). I tried searching on this but couldn't find much, Any ideas?
I have a problem accessing a folder in the DataStage Director. The job in that folder seems to have been locked and I am not able to log out the process using the clean up resources option. I've even tried DS.TOOLS from the administrator, even that doesn't help . I cannot access any of the jobs in that particular folder where the locked job is located, the director just hangs when I try doing that. I can access the jobs from the designer but not the locked out job (gives out a message saying 'job being accessed by another user'). I tried searching on this but couldn't find much, Any ideas?
Regards,
ssh023
ssh023
There is a FAQ that may help. Here is the viewtopic.php?t=95371
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
Re: job locked, clean up resources not working
Did you try the following:ssh023 wrote:Hi,
I have a problem accessing a folder in the DataStage Director. The job in that folder seems to have been locked and I am not able to log out the process using the clean up resources option. I've even tried DS.TOOLS from the administrator, even that doesn't help . I cannot access any of the jobs in that particular folder where the locked job is located, the director just hangs when I try doing that. I can access the jobs from the designer but not the locked out job (gives out a message saying 'job being accessed by another user'). I tried searching on this but couldn't find much, Any ideas?
1. Login to the Datastage server and do LIST.READU
2. Note the 'Userno'
3. Do: UNLOCK USER <Userno> ALL
This should work. Else, note the PID for the job in LIST.READU and do DS.TOOLS...option 5...then option 7...then enter PID at the prompt and this should help clear out the lock.
Vivek Gadwal
Experience is what you get when you didn't get what you wanted
Experience is what you get when you didn't get what you wanted
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
Re: job locked, clean up resources not working
Did you try the following:ssh023 wrote:Hi,
I have a problem accessing a folder in the DataStage Director. The job in that folder seems to have been locked and I am not able to log out the process using the clean up resources option. I've even tried DS.TOOLS from the administrator, even that doesn't help . I cannot access any of the jobs in that particular folder where the locked job is located, the director just hangs when I try doing that. I can access the jobs from the designer but not the locked out job (gives out a message saying 'job being accessed by another user'). I tried searching on this but couldn't find much, Any ideas?
1. Login to the Datastage server and do LIST.READU
2. Note the 'Userno'
3. Do: UNLOCK USER <Userno> ALL
This should work. Else, note the PID for the job in LIST.READU and do DS.TOOLS...option 5...then option 7...then enter PID at the prompt and this should help clear out the lock.
Vivek Gadwal
Experience is what you get when you didn't get what you wanted
Experience is what you get when you didn't get what you wanted
Thanks all for the reply, I tried doing the LIST.READU option by logging out the 'USERNO' from the DS Server and also the DS.TOOLS option to log out the pid# related to that particular job. Both the options do not work. I tried getting the status of all the processes for the job using DS.TOOLS. It gives out a message like this....
cannot open executable job file RT_CONFIG
cannot get any status for the job
cannot find any process numbers for the stages in the job
I couldnt figure out the bug from the above three messages, please help....
cannot open executable job file RT_CONFIG
cannot get any status for the job
cannot find any process numbers for the stages in the job
I couldnt figure out the bug from the above three messages, please help....
Regards,
ssh023
ssh023
Thanks all for the reply, I tried doing the LIST.READU option by logging out the 'USERNO' from the DS Server and also the DS.TOOLS option to log out the pid# related to that particular job. Both the options do not work. I tried getting the status of all the processes for the job using DS.TOOLS. It gives out a message like this....
cannot open executable job file RT_CONFIG
cannot get any status for the job
cannot find any process numbers for the stages in the job
I couldnt figure out the bug from the above three messages, please help....
cannot open executable job file RT_CONFIG
cannot get any status for the job
cannot find any process numbers for the stages in the job
I couldnt figure out the bug from the above three messages, please help....
Regards,
ssh023
ssh023
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Has the job been deleted? Can you find it in any of the clients? Try re-compiling the job (which may not work). Try running the DS.REINDEX ALL command when you have exclusive access to the project - it may be that the CATEGORY index on DS_JOBS and/or DS_JOBOBJECTS needs to be rebuilt.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I suspect that the job itself had been deleted but the index(es) had not been updated. DS.REINDEX does not remove deleted jobs from the Repository, but will remove out-of-date references to deleted jobs from Repository indexes.
The command to remove partially deleted jobs is DS.CHECKER.
The command to remove partially deleted jobs is DS.CHECKER.
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.