This Db2 for z/OS News from the Lab blog entry was originally published on 2018-11-16.
In a series of recent articles in the IDUG Content Blog, IBM Db2 for z/OS developer Xiaohong Fu discusses the major Db2 temporal data enhancements delivered in Db2 12 for z/OS, and continuing in Db2 for z/OS continuous delivery, including: temporal logical transactions, temporal referential, and replication and temporal query enhancements for temporal auditing.
This article provides a brief roadmap of major temporal support across Db2 10, Db2 11, and Db2 12, and provides a detailed description of the recent enhancement for temporal auditing, which was delivered in Db2 12 function level 503. Read the article.
With temporal logical transaction support in Db2 12, Db2 allows an application to specify and manage the scope of temporal work easily and concisely. Read the article.
Compared to traditional referential integrity (RI), temporal RI is an even stronger condition that can be enforced between two tables with business time periods. For every row in a child table, one or more corresponding rows in a parent table exist with matching key and the business time periods of the parent rows. Read the article.
Xiahong Fu is a Db2 for z/OS Developer at IBM Silicon Valley Laboratory
#Db2forz/OS#db2z/os#Db2Znews