Recent releases of Db2 have introduced new SQL functionality that improves the functionality and productivity of application developers. But the DBA can also take advantage of some of the “new” Db2 SQL to improve their own productivity.
Db2 for Linux, UNIX, and Windows Version 11.5 GA comes with the tech preview of a new feature called “Advanced Log Space Management” (ALSM). Although this new feature still has some limitations and isn’t ready yet for productive use, I’d like to show you how it works and its benefits.
DBA's are notoriously conservative when it comes to migrating data to new types of objects. Our theme seems to be "if it ain't broke, don't fix it!" IBM has decided to encourage those of us on DB2 for z/OS to migrate our data to Universal Table Spaces (UTS) by essentially deprecating non UTS space