DSXchange

Hi,
i am trying to update a job earlier it usually takes 10 minutes to update
but today its hanging like on 25000 rows giving 25000 rows 40rows/sec
but its not moving from 25000 (total number of count is 27610) ,
As it was running good for 1 week , Plz suggest.
Thanks
Bobby

Probably a locking conflict where someone else has a record locked that your job is trying to update. DataStage will wait for it to become available before it moves on. Check with your DBA...

other jobs do hang too will rebot server help

Hi,
Also remove the locks on the table and clear the process id assciated with this job on Unix server.

Ketfos

hi,
just a clarifaction if i reboot the datastage server will it take care of
locked jobs ? or i have to still kill them ?
thanks
bobby

Hi,
No, You need to kill them.

Ketfos

i have a job which was stopped via director when i am compling it
its saying job being mointered if i make copy of it and try to delete it
will it help 2) why that error is coming (as i am only accessing that job)
thanks
bobby

hi,
was trying to delete that job its saying) cannot get exclusive acess to executable file for job )
plz advise
thanks
bobby

Hi,
Go to Datastage Director and look for process id associated with these jobs. Then kill them.
Until the locks remains, you will keep on getting the messages.

Ketfos

I WAS TRYING TO CLEAR JOB
BY DS.TOOLS --5 ---THEN 11 THEN JOBNAME NOW WHEN I SAY YES
IT HANGS BIT WHEN I SAY NO ITS OK,
PLZ ADVICE
Thanks
Bobby

Hi,
It could be that the process is taking time and is slow. GIve it some more time and see if you get back the response.

Ketfos

hi,
i have waited more then 20 min still waiting did it takes too long.(any other option to find pid)
thanks
bobby

What ELSE (non-DataStage things) might be happening in the database that might hold locks for a long time? For (non-exhaustive) example backups, batch loads, defunct processes owning locks.