We have Batch program which insert around 1 million rows in a partitioned table.
A suggestion has been given to write the records to a file and then load them to the table using IBMLOAD or BMC LOAD.
What is general guideline in such cases where application is processing large volume of data and inserting in the DB2 table ?
Mass Inserts with Restart Capability or Loads using file compromising on Restartability...