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