As per my requirement i have to write some transaction data to DB2 table. As i cant give explicit commit or rollback. I am thinking to write the data to either MQ or Flat file and later using a batch job will upload to the DB2 table.
Can anyone suggest which will be better in case of High Volume Real time data? Approx i will be receiving 3 Million records a day.
The 3 million records are not going to come in a single go. Its the total volume expected by end of day. The application which is going to process the records is triggered every 30 secs. i need to update the audit database for successful/unsuccessful processing of each record.
Since the application doesn't have any explicit commit/rollback. So if a transaction is unsuccessful if i directly update the Audit database, it will be rolled back. Hence considering either MQ or flat file to store the info and later on applying to the database.