You may have heard that the upcoming release of DB2 10 for Linux, UNIX, and Windows includes support for temporal data ("time travel queries"). You know for sure about the DB2 family and that we strive for compatibility across the family members. Thus, I recommend listening in to the upcoming webcast
"Architecting with IBM pureXML and Temporal Data in IBM DB2 10 for z/OS". Even though it says DB2 for z/OS, most of it will apply to DB2 LUW as well.
IBM Distinguished Engineer Guogen Zhang will be the speaker next Tuesday, April 24th. You will learn about the following:
- Improving productivity, performance and regulatory compliance with XML and time-based data
- Automatically managing multiple versions of data
- Enforcing uniqueness over time
- Reducing query complexity and enhanced analysis of time-dependent events
- Eliminating hard-coding temporal logic into triggers, stored procedures, or home-grown applications
As I said, the webcast should be interesting and apply to those working with DB2 LUW, too.