DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
dsusersaj



Group memberships:
Premium Members

Joined: 17 Dec 2007
Posts: 160

Points: 1134

Post Posted: Wed Dec 21, 2011 3:56 pm Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Parallel
OS: Unix
I have a job which reads from a database table TABLE-A, joined with a dataset and then update the same table TABLE-A. TABLE-A is a db2 table installed in mainframe Z/OS. My job runs fine in dev region with 600k records. I am using db2 API stage for reading and writing into the table.

My question is ,will this ever end up in a deadlock as I am reading and writing to the same table in one job?. I have heard people facing deadlock issues when using db2 enterprise stage in the same job.

I do not want to migrate job to SIT where there are large amount of data and the job be hung. So your valuable suggestions are needed.

Thnak you.
shamshad



Group memberships:
Premium Members

Joined: 25 Aug 2004
Posts: 147
Location: Detroit,MI
Points: 1383

Post Posted: Wed Dec 21, 2011 7:00 pm Reply with quote    Back to top    

Lets assume that even if there won't be a deadlock issue, why would you want to have a job that reads and update the same table? Isn't one of the best practice is to separate each database operation (insert, delete, update etc)?

_________________
Datawarehouse Consultant
Rate this response:  
Not yet rated
dsusersaj



Group memberships:
Premium Members

Joined: 17 Dec 2007
Posts: 160

Points: 1134

Post Posted: Thu Dec 22, 2011 8:22 am Reply with quote    Back to top    

It is a best practice to seperate database operations. But I thought datastage internal processes executes in such a way that the update happens for rows that have been read and transferred to the output link.

Anyways, I will just seperate out the jobs. That would be a safer bet I beleive.

Thanks
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours