Start of change

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.
  • Restrictions for system-period data versioning
    When a table is enabled for system-period data versioning, certain restrictions apply.
  • 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.
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)
End of change