In the early days of DB2 for z/OS, pretty much every change to a table would result in an unload-drop-recreate-load of the table. This article will talk about how the ALTER table in DB2 12 for z/OS has evolved from DB2 11 for z/OS and what you need to know from a practical point of view.
In DB2 11
Db2 introduced the MERGE statement in version 9 and made significant enhancements in Db2 12. This article shows you how.
In Part 2, we will examine how to exploit Application Compatibility (APPLCOMPAT) which was introduced in DB2 11, and Function Levels which is introduced in DB2 12 to safely manage change. The levels of APPLCOMAT you can specify is limited by the Function Level of your system.
This two-part article will introduce Continuous Delivery, the problems with traditional delivery and how Continuous Delivery helps address those problems in Part One. In Part Two, we will delve deeper into the mechanisms of DB2 12 Continuous Delivery.
You may or may not have heard this rumor, “DB2 12 for z/OS is the last version”. Let me first of all reassure you DB2 is not going away. Quite the opposite.