Articles & Content

Archives

I/O, I/O, it's off to Disk I go - I/O Optimization, Elimination, & SSD (C02)

Topic: DB2 for LUW

Subtopic: 2011



DATE: 2011-5-3 (02:00 PM - 03:00 PM)
SPEAKERS: Scott Hayes (DBI ), Andrew Endicott (Cardinal Health)

When asked "What DB2 LUW Challenges do you struggle with the most?", the majority of people in The DB2Night Showâ„¢ (www.DB2NightShow.com) 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.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Slow I/O, Bulk I/O, Fast I/O, and Painful I/O

I/O Optimization and Object Placement

Learn from Mistakes of Others - DON'T DO THIS!

Compression, SSD Tips, and performance measurements

Case Studies and DB2 Customer Success Stories



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.