Adopting temporal tables in DB2, Part 2, Advanced migration scenarios for system-period temporal tables

From the developerWorks archives

Matthias Nicola and Jan-Eike Michels

Date archived: January 12, 2017 | First published: October 25, 2012

The temporal capabilities in IBM® DB2® 10 provide powerful tools for time-based data management. At the core of the temporal features in DB2 are three types of temporal tables: system-period, application-period, and bitemporal. This "Adopting temporal tables in DB2" series explains how to migrate existing tables and temporal solutions to temporal tables in DB2. Part 1 of the series describes basic scenarios for adopting system-period temporal tables in DB2, and Part 2 discusses three additional and slightly more advanced scenarios for migrating to system-period temporal tables.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=841549
ArticleTitle=Adopting temporal tables in DB2, Part 2: Advanced migration scenarios for system-period temporal tables
publish-date=10252012