update taking forever

bobby · Post by **bobby** » Tue Sep 21, 2004 11:56 am

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

chulett · Post by **chulett** » Tue Sep 21, 2004 12:06 pm

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

bobby · Post by **bobby** » Tue Sep 21, 2004 12:13 pm

other jobs do hang too will rebot server help

ketfos · Post by **ketfos** » Tue Sep 21, 2004 12:22 pm

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

Ketfos

bobby · Post by **bobby** » Tue Sep 21, 2004 12:41 pm

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

ketfos · Post by **ketfos** » Tue Sep 21, 2004 12:50 pm

Hi,
No, You need to kill them.

Ketfos

bobby · Post by **bobby** » Tue Sep 21, 2004 1:02 pm

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

bobby · Post by **bobby** » Tue Sep 21, 2004 1:14 pm

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

plz advise
thanks
bobby

ketfos · Post by **ketfos** » Tue Sep 21, 2004 1:36 pm

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

bobby · Post by **bobby** » Tue Sep 21, 2004 1:53 pm

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

ketfos · Post by **ketfos** » Tue Sep 21, 2004 1:57 pm

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

bobby · Post by **bobby** » Tue Sep 21, 2004 2:17 pm

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

ray.wurlod · Post by **ray.wurlod** » Tue Sep 21, 2004 4:11 pm

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.