View previous topic :: View next topic
|
Author |
Message |
kishpra
New User
Joined: 24 May 2010 Posts: 92 Location: Pune
|
|
|
|
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 |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
|
|
|
|
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 |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
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 |
|
|
RahulG31
Active User
Joined: 20 Dec 2014 Posts: 446 Location: USA
|
|
|
|
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 |
|
|
|