This chapter covers the temporal enhancements of IBM DB2 11 for z/OS, which includes temporal support for views, temporal special registers, and auditing used with temporal tables. Additionally, information is provided about how temporal tables can improve performance and considerations for designing a history table.
5.1 Temporal support for views
Views have been used by DB2 clients intensively to get more data access control. DB2 V11 removed the V10 restriction that a period specification or period clause could only be ...