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