Import Jobs

just4u_sharath · Post by **just4u_sharath** » Mon Mar 10, 2008 7:59 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Mar 10, 2008 9:07 pm

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.

veera24 · Post by **veera24** » Mon Mar 10, 2008 9:55 pm

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

hi,
someone would've opened the job in the Director so better ask them to close it. Then it will work fine.

veera24 · Post by **veera24** » Mon Mar 10, 2008 9:57 pm

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. ...

ray,
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?

chulett · Post by **chulett** » Mon Mar 10, 2008 10:15 pm

Designer. And Ray is addressing the times when it isn't as simple as just closing the job in Designer.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 10, 2008 10:51 pm

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.

virkravi2000 · Post by **virkravi2000** » Tue Mar 11, 2008 7:14 am

Hi Ray,

Kindly advice how to use the command LIST.READU. I was wondering if we need to develop a Datastage Server Routine and use this command as I was able to find LIST.READU command in BASIC Transformer Guide.

ArndW · Post by **ArndW** » Tue Mar 11, 2008 7:32 am

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.

just4u_sharath · Post by **just4u_sharath** » Tue Mar 11, 2008 11:02 am

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.

I am currenlty working on 7.5.2. Can you please let me know how can i use the LIST.READU command.

ArndW · Post by **ArndW** » Tue Mar 11, 2008 11:25 am

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.

just4u_sharath · Post by **just4u_sharath** » Tue Mar 11, 2008 5:58 pm

ArndW 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.

Thankyou

ray.wurlod · Post by **ray.wurlod** » Tue Mar 11, 2008 6:10 pm

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.

DSXchange

Import Jobs

Import Jobs

Re: Import Jobs