IDUG DB2 Tech Conference in Denver, Colorado, USA 2012
Denver Colorado Convention Center, Denver, Colorado
May 14-18, 2012

View Printable Version

DB2 10 for LUW: Time Travel and Compression - H01

Session Number: 355
Track: DB2 10 for Linux, Unix, Windows
Session Type: Podium Presentation
Primary Presenter: Martin Hubel [MHC Inc.]

Room 105 => Tue, May 15, 2012 (12:45 PM - 01:45 PM)

Speaker Bio: Martin Hubel is an independent consultant and has worked extensively with DB2 since 1985. Martin develops and teaches DB2 advanced courses and is recognized as a leading authority in the field. He has been using DB2 Universal Database on Linux, Unix, and Windows since 1993 and has participated in several beta test programs for these platforms. He is an IBM Information Champion, a member of the DB2 LUW SAP Technical Leadership Exchange and a member of the IDUG Volunteer Hall of Fame.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Implementing New DB2 Releases and Features
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators
Technical areas this presentation will apply to: Database Performance (DB2 for LUW)
Objective 1: System-period and application-period tables
-DDL, DML and examples

Objective 2: Bi-temporal tables
-Using both system-period and business-period together

Objective 3: Best practices and implementation
-Uses for each type of table
-Migration to time-based columns

Objective 4: How data compression works
-Turning on data compression
-The history of compression
-Adaptive compression in DB2 10
-The benchmark environment

Objective 5: Compression measurements
-Compression estimation
-Compression actual
-Performance benchmarks
-When to compress data
-When compression doesn’t help

Abstract:  DB2 10 for both LUW and z/OS has introduced “time travel”, which allow users to store and manipulate time based on system and business time. The good news is the new facilities are identical in z/OS and LUW so this is a true cross platform feature.

Deep compression has been enhanced in DB2 10 to further compress at the page level to get even greater compression. It will give customer metrics for disk savings as well as performance benchmarks for queries.

-System-period and application-period tables
-Bi-temporal tables
-Best practices and implementation
-Adaptive compression in DB2 10
-Compression measurements

For questions or concerns about your event registration, please contact