O'Reilly logo

Managing Ever-Increasing Amounts of Data with IBM DB2 for z/OS: Using Temporal Data Management, Archive Transparency, and the DB2 Analytics Accelerator by Xiao Hui Wang, Craig McKellar, Claire McFeely, Mehmet Cuneyt Goksu

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Additional considerations
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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required