Creating temporal tables

You can create a temporal table, which is a table that records the period of time when a row is valid.

Temporal tables and data versioning
A temporal table is a table that records the period of time when a row is valid.
Creating a system-period temporal table
You can create a temporal table that has a system period and define system-period data versioning on the table, so that the data is versioned after insert, update, and delete operations.
Restrictions for system-period data versioning
When a table is enabled for system-period data versioning, certain restrictions apply.
System-period temporal tables and the switch from daylight saving time to standard time
You might get SQL errors if you update system-period temporal tables during the hour before the switch to standard time.
Creating an application-period temporal table
An application-period temporal table is a type of temporal table where you maintain the values that indicate when a row is valid. The other type of temporal table is a system-period temporal table where Db2 maintains the values that indicate when a row is valid.
Creating bitemporal tables
You can create a bitemporal table that maintains both system-based historical information and application period information.
Scenario for tracking auditing information
Db2 can track some basic auditing information for you. Db2 can track when the data was modified, who modified the data, and the SQL operation that modified the data.
Finding the name of a history table
A history table is a base table that is associated with a system-period temporal table. A history table is used by Db2 to store the historical versions of the rows from the associated system-period temporal table.
Querying temporal tables
You can query a temporal table to retrieve data, based on the time criteria that you specify.

Parent topic: Implementing Db2 tables

Related information

Managing Ever-Increasing Amounts of Data with IBM Db2 for z/OS: Using Temporal Data Management, Archive Transparency, and the IBM Db2 Analytics Accelerator for z/OS (IBM Redbooks)