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(s)/
    Time(s):

    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 support@idug.org


    Copyright © 2014 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact