Posted on 9/25/2026
| Presented by: Presented by Michael Roecken, Senior Software Developer, IBM Canada We are excited to continue our Db2 12.1 webinar series with another highly informative session on The DB2Night Show! In this episode, Michael Roecken, Senior Software Developer at IBM Canada, provided an excellent technical deep dive into the latest Db2 Backup and Recovery Enhancements, focusing on performance improvements, usability, reliability, and recovery management. Michael has extensive experience designing and developing Db2 availability and recovery capabilities, including backup and restore, crash recovery, rollforward recovery, HADR, transaction logging, and database migration. As enterprise databases continue to grow in size and complexity, organizations face increasing challenges in reducing backup windows, ensuring data integrity, managing transaction logs, and meeting demanding recovery objectives. Michael explained how IBM Db2 12.1 introduces significant enhancements to address these challenges, making backup and recovery operations faster, more efficient, reliable, and easier to manage. "The DB2Night Show Episode #287: Db2 Backup and Recovery Enhancements: Performance and Usability". Replays available in MP4 formats! |
Show Hosts: Mohan's CommentaryOne of the most important responsibilities of a database administrator is ensuring that critical business data can be recovered quickly and reliably when something goes wrong. In this episode, Michael provided valuable insights into how IBM Db2 continues to evolve its backup and recovery capabilities to meet the demands of modern enterprise environments. Topics covered during the session included: Backup Intra-Tablespace Parallelism (ITP): Improved backup performance by allowing multiple backup media agents to process large tablespaces concurrently, reducing backup bottlenecks. Reduced Buffer Pool Flushing: Enhancements that reduce unnecessary flushing of dirty pages, allowing online backups to start sooner. Backup Page Verification: Automatic verification of database pages during backup to detect corruption early and improve backup reliability. Transaction Log Retention: Improvements using LOG_DISK_CAP to reduce expensive archive log retrievals during online backups. Automatic Backup to Remote Storage: Enhanced integration with cloud object storage, including Amazon S3 and IBM Cloud Object Storage. Backup History File Enhancements: Improved tracking of backup image sizes, compression, encryption, and recovery metadata. Asynchronous History File Pruning: Decoupling history pruning from backup execution to improve backup completion times. Db2 pureScale Recovery Enhancements: Improved recovery capabilities involving member topology changes and restoration of backup images. IBM Storage Protect Integration: Better visibility into backup image and archived log sizes through db2adutl. Enhanced Backup and Restore Monitoring: Improved db2pd -barstats output, including log processing statistics and more readable execution times. One particularly interesting enhancement was Backup Intra-Tablespace Parallelism, which addresses a long-standing performance limitation when backing up databases containing a few exceptionally large tablespaces. Michael demonstrated how Db2 can divide large tablespaces into smaller segments and distribute the workload across multiple backup media agents, significantly improving backup performance when sufficient I/O capacity is available. Another important discussion focused on Backup Page Verification, which helps detect corrupted database pages during the backup process rather than discovering corruption when a restore is needed. The improvements to transaction log management, particularly the ability to retain required logs locally during backup operations, were also highly relevant for environments with large databases and remote archive storage. Michael also explained how asynchronous history file pruning helps eliminate unnecessary delays at the end of backup operations, providing more predictable backup completion times. We also sincerely thank all attendees, speakers, IBM Champions, customers, and Db2 professionals who continue to support and grow The DB2Night Show community worldwide. Subscribe to The DB2Night Show for more Db2 technical deep dives, AI and Generative AI discussions, product updates, performance topics, modernization strategies, and conversations with IBM Db2 experts.
Are you following The DB2Night Show on Twitter?Go to twitter.com/db2nightshow and click Follow. You can also see recent tweets containing the hash tag #DB2Night by Clicking Here.Get the Download ReplaysTo download a recorded replay of Episode 285 in MP4 format:"
Episode 287 23 October 2026 Db2 Backup and Recovery Enhancements: Performance, Usability, and Reliability Have an iLife, iDevice, iPod, iPad, or iPhone? Download the MP4format! Michael graciously made the PDF of Episode 287 available at this link:
Handout (PDF) Follow the Db2Night Show channel on Youtube!! Did you learn something from this show?Share a great show with your friends and followers:
|