The DB2Night Show Episode скачать в хорошем качестве

The DB2Night Show Episode

The Db2Night Show – Episode #270 Recap Topic: Db2 Availability and Recovery – What’s Next? Presenter: Michael Roecken, Senior Software Developer, IBM Canada Date: June 27, 2025 This episode spotlighted the exciting advancements in Db2 12.1.2, with a strong focus on high availability, disaster recovery (HADR), backup improvements, and enhanced operational transparency. What’s New in Db2 Availability and Recovery Backup Enhancements Intra-Tablespace Parallelism (ITP): Improved backup performance by enabling parallel processing within a single tablespace. Backup Metadata in History File: Backup size information now included. Encrypted backup details captured. Increased size limit for the COMMENT field for better annotations. Logical Backup Enhancements: New LOGICAL_BACKUP_DETAILS_TAB table function to list backup image contents. Support for Storage Access Alias (DB2REMOTE) instead of hardcoded access keys. History File Improvements More complete metadata now stored for audit, compliance, and troubleshooting. Automatic History File Pruning for backups created using automatic backup. Storage & Log Archive Enhancements Streaming to Object/Remote Storage now supported for archived log files (v12.1.2). Log File Validation During Archive ensures data integrity in archived logs. Support for S3-Compatible Storage for backups – expands cloud integration options. HADR and Recovery Improvements HADR Major Version Upgrade with Reads on Standby (RoS) support – minimizes downtime. SSL Support and Hostname Validation now extended to pureScale environments. Remove Restriction on Restore/Rollforward Across Topology Change – simplifies recovery scenarios in pureScale. UPGRADE DATABASE now supports topology changes in v12.1.2. Operational Enhancements db2adutl now displays object sizes in 12.1.2 – helpful for backup management. New configuration option to control default schema type and enable row modification tracking by default.