Watch recording (logged in Tridex members only)
Session title: Do I really need to worry about my Commit Frequency? An introduction to Db2 Logging.
Session abstract: Does it really matter how often my application commits its activity? Yes, yes it does. 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.
Db2 writes log records for all of the Inserts, Updates, and Deletes that happen to any table.
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?
Speaker bio: Andrew Badgley is the Lead Product Owner for the Database Management for Db2 for z/OS Administration, Backup & Recovery, Performance, and Utility products at Broadcom. He has 24 years of experience with these products as Developer, Support Engineer, Support Engineering Manager, Scrum Master, and Product Owner. His areas of expertise include Db2 Log Reporting, Data Recovery, and Database Design. He is also the owner of the CA Db2 Tools 20.0 Validation Project.