Import Jobs
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
Import Jobs
When i tried to import job through manager to TEST environment, i got the below error.
"Cannot get exclusive access to job 'jobname'".
How can i rectfy this. Can you please let me know whats happening in the backend
"Cannot get exclusive access to job 'jobname'".
How can i rectfy this. Can you please let me know whats happening in the backend
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Find out, perhaps by using the LIST.READU command, who has the job open. Ask them nicely to close it. If the lock is owned by a redundant process, use dsdlockd -p command to clean up.
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.
Re: Import Jobs
hi,just4u_sharath wrote:When i tried to import job through manager to TEST environment, i got the below error.
"Cannot get exclusive access to job 'jobname'".
How can i rectfy this. Can you please let me know whats happening in the backend
someone would've opened the job in the Director so better ask them to close it. Then it will work fine.
ray,ray.wurlod wrote:Find out, perhaps by using the LIST.READU command, who has the job open. Ask them nicely to close it. If the lock is owned by a redundant process, use dsdlockd -p command to clean up. ...
That problem aforementioned will be rectified by closing the job in the director itself right?And could u pls. explain how ur criteria will work?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Jobs can be open/locked in Manager, Designer, Director (log) or Director (Monitor) and from the operating system (dsjob or hack programs). The LIST.READU command allows you to find the culprit.
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: 1
- Joined: Thu Jun 15, 2006 6:26 am
- Location: Chandigarh
It takes a certain amount of experience to interpret the LIST.READU command output and it is not worth the time to do this. The damage you can do in a running environment with kill and UNLOCK using information gleaned from the LIST.READU and PORT.STATUS output is substantial.
In additional to the known and proven tools, once you get to V8 you can use IIS and quickly identify processes and stop them.
In additional to the known and proven tools, once you get to V8 you can use IIS and quickly identify processes and stop them.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
I am currenlty working on 7.5.2. Can you please let me know how can i use the LIST.READU command.ArndW wrote:It takes a certain amount of experience to interpret the LIST.READU command output and it is not worth the time to do this. The damage you can do in a running environment with kill and UNLOCK using information gleaned from the LIST.READU and PORT.STATUS output is substantial.
In additional to the known and proven tools, once you get to V8 you can use IIS and quickly identify processes and stop them.
The command is easy, "LIST.READU EVERY" but the output is complex to interpret.
The best way to learn this is to download the UniVerse 10 documentation from the IBM website and locate the chapter describing the LIST.READU command.
Then you will most likely have to cross reference and learn about the different types of lock (record, group, exclusive, shared, etc.). Note that the user number is the DataStage number and that the PIDs which are longer than 5 digits are cut off at the left.
There is more involved than is good to explain here.
The best way to learn this is to download the UniVerse 10 documentation from the IBM website and locate the chapter describing the LIST.READU command.
Then you will most likely have to cross reference and learn about the different types of lock (record, group, exclusive, shared, etc.). Note that the user number is the DataStage number and that the PIDs which are longer than 5 digits are cut off at the left.
There is more involved than is good to explain here.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
ThankyouArndW wrote:The command is easy, "LIST.READU EVERY" but the output is complex to interpret.
The best way to learn this is to download the UniVerse 10 documentation from the IBM website and locate the chapter describing the LIST.READU command.
Then you will most likely have to cross reference and learn about the different types of lock (record, group, exclusive, shared, etc.). Note that the user number is the DataStage number and that the PIDs which are longer than 5 digits are cut off at the left.
There is more involved than is good to explain here.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A better fit is to download the UniVerse 9.6 documentation.
UniVerse 9.6 is the last release actually to have been used as the DataStage engine. There are things in UniVerse 10 that are not in DataStage.
UniVerse 9.6 is the last release actually to have been used as the DataStage engine. There are things in UniVerse 10 that are not in DataStage.
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.