Articles & Content


Managing Data with History (F08)

Topic: 2011 NA

Subtopic: DB2 for z/OS

DATE: 2011-5-4 (02:45 PM - 03:45 PM)
SPEAKERS: Larry Koenen (State Farm Insurance )

For years, you have been facing the problem of managing different versions of application data. With new regulatory and compliance laws requiring historical data to be maintained over years, the problem is becoming more complex managing different versions of data. This session will give a short overview on the new capability in DB2 10 for z/OS to control the management of application data based upon time via table definitions and new SQL clauses. State Farm will walk through use cases that have a need to track versions of data over time, compare solutions for those use cases developed with and without DB2 10 functionality, and share early experiences and usage considerations for the new functionality.

EXP. LEVEL: Intermediate


Basic understanding of history in data

Understanding of where history embeded in the data is important

Overview of new SQL features for accessing history

Overview of database concepts for managing history in the database

Examples of where storing history makes sense in the database.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.