DB2 for Linux, UNIX and Windows

Always-on transactions. Fast answers. Simply delivered.

Primary tab navigation

DB2 Time Travel Query

It is expensive and technically complex for businesses to develop their own infrastructure for temporal data management, such as additional tables, triggers, and application logic. Time Travel Query makes your database time-aware and keeps a history of your data changes by using temporal tables. You can travel to the past and the future, and query your data as it appeared at different points in time without having to build, maintain, and administer a complex temporal infrastructure.


DB2 Time Travel Query helps you:

For example, a database can store the history of a table (deleted rows or the original values of rows that have been updated) so you can query the past state of your data. You can also assign a date range to a row of data to indicate when it is deemed to be valid by your application or business rules. For many businesses there are important reasons to preserve the history of data changes. Without this capability in the database, it is expensive and complex for businesses to maintain audit trails for regulatory compliance.