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