Temporal Support of Db2 for z/OS – Part III Temporal RI By Xiaohong Fu, Db2 for z/OS Development, Silicon Valley Lab, IBM Background and Motivation What is referential integrity (RI)? Referential integrity (RI) is the state in which all values of all foreign keys are...
Temporal Support of Db2 for z/OS – Part I Temporal Auditing Enhancements in Db2 12 Continuous Delivery Xiaohong Fu, Db2 for z/OS Development, Silicon Valley Lab, IBM Abstract This article series discuss the major Db2 temporal enhancements delivered in Db2 12 for z/OS...
Temporal Support of Db2 for z/OS – Part II Temporal Logical Transaction Xiaohong Fu, Db2 for z/OS Development, Silicon Valley Lab, IBM Temporal Logical Transaction Background and Motivation Transactions are omnipresent in today’s database systems, providing data integrity...
“As time goes by…..” DB2 for z/OS continues to enhance support for temporal data. Since the availability of the initial temporal support with DB2 10 for z/OS, the functionality has been extended several times. The subject of this article is one of the temporal extensions, the temporal special...
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...