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

View Printable Version

I/O, I/O, it’s off to Disk I go – I/O Optimization, Elimination, & SSD

Session Number: 1899
Track: DB2 9.7 for LUW (C)
Session Type: Podium Presentation
Primary Presenter: Scott Hayes [President & CEO - DBI Software]
Time: Nov 17, 2011 (08:30 AM - 09:30 AM)
Room: Aquarius

Speaker Bio: Scott Hayes is an IBM DB2 GOLD Consultant and IBM Information Management Champion, a frequent speaker at IDUG and regional DB2 User Group Events, is the host of The DB2Night Show‚Ñ¢ Webinar series, and author of the widely read DB2 LUW Performance Blogs. He has worked with DB2 on distributed platforms since V1 and he reads IBM documentation instead of novels for entertainment. Scott is also President & CEO of DBI, an IBM Advanced Business Partner focused on DB2 LUW and Oracle performance. Andrew Endicott is a Senior Database Manager at Cardinal Health.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Managing Performance
Presentation Platform: Select a Value
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, New Users, IT Managers
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), High Availability (DB2 for LUW), New Release (DB2 for LUW), SQL and XML Performance, User Experiences
Objective 1: Slow I/O, Bulk I/O, Fast I/O, and Painful I/O
Objective 2: I/O Optimization and Object Placement
Objective 3: Learn from Mistakes of Others – DON’T DO THIS!
Objective 4: Compression, SSD Tips, and performance measurements
Objective 5: Case Studies and DB2 Customer Success Stories

Abstract:  When asked ‚ÄúWhat DB2 LUW Challenges do you struggle with the most?‚Äù, the majority of people in The DB2Night Show‚Ñ¢ ( studio audiences frequently respond ‚ÄúI/O Bound Databases‚Äù. This technical session will explore multiple facets of DB2 I/O, how it works, how to optimize it, how to eliminate it, how to make friends with the storage administrator, data, index, logs, and tempspace placement, best and worst practices, compression, solid state disk, and a few other tidbits to help DBAs minimize and mitigate their I/O challenges and costs. Customer Case Studies will be shared.

For questions or concerns about your event registration, please contact