IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Updating online Db2 table


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kishpra

New User


Joined: 24 May 2010
Posts: 92
Location: Pune

PostPosted: Fri Aug 12, 2016 2:44 pm
Reply with quote

Hello Team,

I have a requirement to read a flat file and update the DB2 table which is used by online screes/transactions 24x7. The number of records to be updated is around 1 million.
Kinldy let me know the approach for this. Do we need to write a Cobol-DB2 program or a DB2 stored procedure.

Any sample POC would be appreciated.

Thank you.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 765
Location: Whitby, ON, Canada

PostPosted: Fri Aug 12, 2016 6:33 pm
Reply with quote

If I was asked to do this, I would write a Cobol-DB2 program that takes frequent Commits. I would write it to be checkpoint restartable.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3048
Location: NYC,USA

PostPosted: Fri Aug 12, 2016 7:58 pm
Reply with quote

I would rather do a load replace because( I am sure you have full population in that flat file )with share level change which means you have no worries with online queries as the underlying LDS for online is untouched. OR see if this works, We have some process where we create a another same table which is secondary one and load all the data from online table once you complete your work on secondary table then flip the names so that then secondary becomes primary and vice versa.
Back to top
View user's profile Send private message
RahulG31

Active User


Joined: 20 Dec 2014
Posts: 446
Location: USA

PostPosted: Fri Aug 12, 2016 8:49 pm
Reply with quote

I agree with don. It needs to be a COBOL-DB2 program with frequent commits. But I don't think it needs a restart capability.

This program, I suppose, is going to be a one time only and we can always write the update query in such a way that it doesn't update the already updated values. So, no need for an extra restart coding.

.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
No new posts Dynamically pass table name to a sele... DB2 2
Search our Forums:

Back to Top