Referential integrity (RI) is the state in which all values of all foreign keys are valid. Both traditional RI and temporal RI are relationships between pairs of tables, in which the business rules are represented. In Db2 V8, informational RI (with NOT ENFORCED keyword) was added to benefit certain
This article series discuss the major Db2 temporal enhancements delivered in Db2 12 for z/OS and Db2 for z/OS Continuous Delivery (CD), e.g., temporal logical transaction, temporal RI, and replication and temporal query enhancements on temporal auditing.
With the temporal logical transaction support of Db2 12, Db2 allows an application to specify and manage the scope of temporal work easily and concisely. Both physical and temporal logical transactions can happen sequentially and/or concurrently without violating the integrity of the data. In additi