This month we will be focusing on temporal table design and Archive tables. DB2 11 for z/OS brought many interesting improvements for temporal tables, which will be addressed during the upcoming month. On top of that in gave us archive tables, which we can use for “transparent archiving”. As a first
In the past, it was up to the user to organize not only the archiving process, but also ensure proper coding of SQL to include or exclude the archive data. This article provides an overview of the new transparent archive capabilities introduced by DB2 11 for z/OS.