IDUG EMEA has ended
Back To Schedule
Sunday, October 23 • 14:00 - 15:00
G03 | Do I Really Need to Worry about my Commit Frequency? An Introduction to Db2 Logging

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

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?

avatar for Andrew Badgley

Andrew Badgley

Lead Product Owner - Database Tools, Broadcom
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 23 years of experience with these products as Developer, Support Engineer, Support Engineering Manager, Scrum... Read More →

Sunday October 23, 2022 14:00 - 15:00 BST
1 | Carrick