Skip to main content

Techdocs Library > White papers >

DB2 for Z/OS: Introduction to temporal tables



Document Author:

Venkata R Mallina


Document ID:

WP102698


Doc. Organization:

Global Technology Services


Document Revised:

03/07/2017


Product(s) covered:

z/OS







Abstract: As part of data management scenarios, any update and deletion of data requires and saving old data called version data in tables. In RDMS this is possible by way of temporal tables. Temporal tables are the tables used to manage system time sensitive data (providing capability to query old snapshot of data for auditing) and business time sensitive data (providing period where the data is valid for business). This paper caters to the explanation how all these can be implemented in DB2 for Z/OS and also learn about the features of temporal tables in DB2 10 and DB2 11

DB2 for Zos: Temporal tables.pdfDB2 for Zos Temporal tables.pdf



Classification:

Software

Category:

Backup and Recovery

Solution(s):

Big Data and Analytics



Platform(s):

IBM System z Family

S/W Pillar(s):

Information Management

O/S:

MVS

Keywords:

DB2 temporal tables, Temporal tables, DB2 history tables


The Techdocs Library
Is this your first visit to Techdocs (the Technical Sales Library)?

Learn more


Techdocs QuickSearch

: