Advantages of Database over File System

[@harisankarraj]

background music disturbance a lot

[@mainframemadeeasy]

@@harisankarraj ok will check and remove the music

[@poornimasaravanan9389]

Sir.. how to select commit frequency for a high volume updates to db2 say 5 million records . Do we have a formula? Or standard to follow? Please explain

[@mainframemadeeasy]

No fixed formula You can take a decision based on the following factors 1) Duration of Job 2) Number of Records updated 3) How soon we need to release records for other Transactions or how much time we can hold 4) Chances of Job to Abend Or an average of say 10000 records will be the frequency I chose for 5M records updation

[@mainframemadeeasy]

Or you can choose to commit after every set of record category