unable to delete job
Moderators: chulett, rschirm, roy
unable to delete job
Im unable to delete the job using director, manager, designer.
* Tried cleaning up the reources, logs
* Tried using ds.tools in Administrator->command
Process performed in Command using ds.tools
(4-for admin previlege, then 7 for clean up the lock, then giving the process id, then enter yes)
Error message: "Cannot get exclusive access to job cmbatjbs"
Please provide solution to this issue, i tried information provided in the forum, still no luck.
* Tried cleaning up the reources, logs
* Tried using ds.tools in Administrator->command
Process performed in Command using ds.tools
(4-for admin previlege, then 7 for clean up the lock, then giving the process id, then enter yes)
Error message: "Cannot get exclusive access to job cmbatjbs"
Please provide solution to this issue, i tried information provided in the forum, still no luck.
thanks for replying chulett.
I checked the team to find out whether anybody is opened the job or viwing the log, but no one opened or view the log.
I also got the job number and checked the cleanup resource and cleared everything and tried to delete the job, still no luck.
Once the try to delete and get the error message, then i check the cleanup resource for the job id and found there is a different no in the cleanup resource.
Still no luck. IS there anything like any temp folder of the job which holds the file? so that i can navigate that folder and delete that file. which might resolve the issue.
I checked the team to find out whether anybody is opened the job or viwing the log, but no one opened or view the log.
I also got the job number and checked the cleanup resource and cleared everything and tried to delete the job, still no luck.
Once the try to delete and get the error message, then i check the cleanup resource for the job id and found there is a different no in the cleanup resource.
Still no luck. IS there anything like any temp folder of the job which holds the file? so that i can navigate that folder and delete that file. which might resolve the issue.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
NO!!!
This is a database, not a set of files in a directory.
Execute this command in an operating system shell.
Substitute for $jobname as appropriate.
This will tell you information about the lock on the job, including the process id of the lock's owner. If that process no longer exists
then - and only then - is it safe to release the lock.
Get back with your discovery about the lock and we'll then talk about where to go from there.
This is a database, not a set of files in a directory.
Execute this command in an operating system shell.
Code: Select all
$DSHOME/bin/list_readu | grep $jobname
This will tell you information about the lock on the job, including the process id of the lock's owner. If that process no longer exists
Code: Select all
ps -ef | grep $pid | grep -v grep
Get back with your discovery about the lock and we'll then talk about where to go from there.
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.
thanks ray,
I tried entering the command:
list_readu | grep $cmbatjbs
I got the message stating
"sh: cmbatjbs: Parameter not set.
Abnormal Termination of Datastage.
Fault type is 13, Layer type is unknown."
If i enter the command like
list_readu | grep cmbatjbs
I dont get any messages
What to do now, Is there any other way i can delete the job.
Note: In the mean time I'm also getting "Abnormal Termination of stage $jobname: TRN_PASS (transformer stage) detected"
Error message. This message occur in all other jobs too.
Does the above error be the cause for all?..
I tried entering the command:
list_readu | grep $cmbatjbs
I got the message stating
"sh: cmbatjbs: Parameter not set.
Abnormal Termination of Datastage.
Fault type is 13, Layer type is unknown."
If i enter the command like
list_readu | grep cmbatjbs
I dont get any messages
What to do now, Is there any other way i can delete the job.
Note: In the mean time I'm also getting "Abnormal Termination of stage $jobname: TRN_PASS (transformer stage) detected"
Error message. This message occur in all other jobs too.
Does the above error be the cause for all?..
2ksaint wrote:Note: In the mean time I'm also getting "Abnormal Termination of stage $jobname: TRN_PASS (transformer stage) detected"
Error message. This message occur in all other jobs too.
![Exclamation :!:](./images/smilies/icon_exclaim.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
2ksaint wrote:I tried entering the command:
list_readu | grep $cmbatjbs
![Confused :?](./images/smilies/icon_confused.gif)
At some point, if you literally cannot figure out what needs to be done to free the resources do you can delete this job... restart DataStage. That would certainly accomplish that goal but if you've never had to do that we'd probably be back here with questions about why it won't restart.
Let's just wait and see what Ray has in mind as the next steps, shall we?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
thanks ray & chulett,
I retried running the command with other job of the same issue and found the result given below:
list_readu | grep CMN_GET_BATCH_ID_JBS
1074987009 402 0 50988 26 RU 14548 sami CMN_GET_BATCH_ID_JBS
Note: Sami is the login id we use and CMN_GET_BATCH_ID_JBS is the job that is need to be deleted.
the above information might help, i think....
I retried running the command with other job of the same issue and found the result given below:
list_readu | grep CMN_GET_BATCH_ID_JBS
1074987009 402 0 50988 26 RU 14548 sami CMN_GET_BATCH_ID_JBS
Note: Sami is the login id we use and CMN_GET_BATCH_ID_JBS is the job that is need to be deleted.
the above information might help, i think....
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I'm going to get you to do a slightly unnecessary step that will make following explanations clearer. I want you to execute the same command but to include the headers from the list_readu command.
Please post the result, as I am not at a UNIX site at the moment and have to do all this from memory.
Code: Select all
list_readu | head -2 ; list_readu | grep CMN_GET_BATCH_ID_JBS
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.