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...
-craig
"You can never have too many knives" -- Logan Nine Fingers
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,
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.