You probably already have noticed that a new release of Db2 for Linux, UNIX, and Windows is available, Db2 11.5.6. You can download the Db2 Fix Pack via the usual support site. The related documentation highlights the following features:
- Improved high availability with Advanced Log Space Management,
- Graph modeling and analysis of Db2 data using IBM Db2 Graph,
- Restrictions lifted on accessing column-organized tables
- Technical preview update to Machine Learning Optimizer
- New Click-to-Containerize utility
Aside from the highlights page, I usually go over the enhancements by category. Here are my personal highlights:
- The SQL enhancements include new NOWAIT and WAIT clauses for SELECT, UPDATE and DELETE statements. You can now specify at the statement level how many seconds to wait for locks.
- High availability, backup, resiliency, and recovery enhancements lists improvement to ADMIN_MOVE_TABLE and also has news on pacemaker.
- And in terms of Workload management enhancements, you can now enable the Adapte Workload Manager.
I am sure that we are going to learn all the details at the IDUG EMEA 2021 conference in Edinburgh, Scotland, in October. Mark your calendars.