Job locked and cannot reimport, delete or unlock it
Posted: Thu Apr 16, 2009 11:21 am
Hello all
I am desperate about a job that I cant update from development, as it is locked in Production server
When trying to delete it, I am getting the typical error message: Cannot get exclusive access
I went to the DS dssh in Unix, and I tried all these things
1. Executed DS.TOOLS, option 4, and tried to logout the process, and all locks in the process
Got this error message: Cannot find any process numbers for stages in job
2. Close all sessions, and execute DS.REINDEX ALL and DS.CHECKER. The checker found the job and just returned message "Job processed". Nothing else
3. Followed steps in this post, and it even returned this:
>UNLOCK NODE 94151 USER 50551 ALL
Clearing Record locks.
Clearing GROUP locks.
Clearing FILE locks.
But nothing worked. I dont know what else to do. I would stop and restart the server, but......there is one inconvenient: this is production, so.....not a good idea
Can you give me any guidance on how to get this fixed? Any help will be really appreciated!
I am desperate about a job that I cant update from development, as it is locked in Production server
When trying to delete it, I am getting the typical error message: Cannot get exclusive access
I went to the DS dssh in Unix, and I tried all these things
1. Executed DS.TOOLS, option 4, and tried to logout the process, and all locks in the process
Got this error message: Cannot find any process numbers for stages in job
2. Close all sessions, and execute DS.REINDEX ALL and DS.CHECKER. The checker found the job and just returned message "Job processed". Nothing else
3. Followed steps in this post, and it even returned this:
>UNLOCK NODE 94151 USER 50551 ALL
Clearing Record locks.
Clearing GROUP locks.
Clearing FILE locks.
But nothing worked. I dont know what else to do. I would stop and restart the server, but......there is one inconvenient: this is production, so.....not a good idea
Can you give me any guidance on how to get this fixed? Any help will be really appreciated!