IDUG DB2 Tech Conference EMEA 2011
    Clarion Congress Hotel, Prague, Czech Republic
    14 - 18 November, 2011

    View Printable Version

    Deep Dive Into LOBs with DB2 10 for z/OS

    Session Number: 1819
    Track: DB2 10 for z/OS (A)
    Session Type: Podium Presentation
    Primary Presenter: Haakon Roberts [IBM]

    Kepler => Wed, Nov 16, 2011 (05:00 PM - 06:00 PM)

    Speaker Bio: Jeff has worked on mainframe performance for IBM for 32 years, and has become known as an expert on DB2 I/O performance, and the synergy between DB2 and storage hardware. Jeff has published numerous articles and papers about DB2 and storage, and has presented many times at user group conferences.
    Audience experience level: Advanced
    Presentation Category: Managing Performance
    Presentation Platform: DB2 for z/OS
    Audiences this presentation will apply to: Data Architects, Database Administrators
    Technical areas this presentation will apply to: Database Performance (DB2 for z/OS), High Availability (DB2 for z/OS), New Release (DB2 for z/OS), Tools and Utilities
    If Tools and Utilities was selected which products: DB2 for z/OS utilities
    Objective 1: New to DB2 10, inline LOBs provide dramatic performance improvements for small LOBs. Learn the performance benefits and best practices for using inline LOBs.
    Objective 2: Learn about other LOB performance enhancements in DB2 10, such as LOB materialization avoidance, and faster Load.
    Objective 3: Learn how to load and unload LOBs with DB2 10 using spanned records, which is dramatically faster than FRV, and works with tape too.
    Objective 4: Learn about the LOB Reorg improvements in DB2 10, enabling improved availability and space management when using partition table spaces.
    Objective 5: Review the LOB improvements that were in DB2 9.

    Abstract:  If you look into today‚Äôs applications, very many use large objects (LOBs) even in heavy transactional environments. The presentation reviews the new LOB performance features in DB2 10 for z/OS which contains numerous enhancements that improve performance, availability and usability. Special emphasis is on the benefits of inline LOBs and its best practices for using LOBs.

    For questions or concerns about your event registration, please contact

    Copyright © 2015 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