Does it really matter how often my application commits its activity? Yes, yes it does. Db2 writes log records for all of the Inserts, Updates, and Deletes that happen to any table.
This session will explore what the Db2 log is, how Db2 writes to it, what a Unit of Work is, and the impact of canceling a Unit of Work with regards to Db2 logging.
Answers will be provided for the following questions:
- What is the BSDS?
- What is the difference between Active and Archive Logs?
- What is a Unit of Work?
- What is the difference between Insert, Update, and Delete log records?
- Why do I care about Data Capture Changes YES/NO?
- What is the importance of the Db2 Log with regards to Point In Time Recovery?
- What log activity happens when I cancel a Unit of Work?
