D17: Storage Concepts for the DB2 DBA; SSDs, Virtualization, Storage Replication, Thin Provisioning
Session Number: 183
Track: DB2 for LUW II
Session Type: Podium Presentation
Primary Presenter: Quentin Presley [Advisory Software Developer - IBM]
Time: Nov 08, 2012 (11:15 AM - 12:15 PM)
Room: Estrel Saal C7
Speaker Bio: Quentin Presley is an DB2 UDB Software Development Manager and technical development lead for the Table Space, Buffer Pool, and Storage Group components. Over the last 8 years Quentin has lead or participated in features including Automatic Storage, Reclaimable Storage, and pureScale. Prior to his work in DB2 Development Quentin worked with DB2 and WebSphere development teams improving the integration of the two products.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Emerging Technology
Presentation Platform: Select a Value
Audiences this presentation will apply to: Data Architects, Database Administrators
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), Disaster Recovery (DB2 for LUW), High Availability (DB2 for LUW), pureScale
Objective 1: Overview of the storage landscape
Objective 2: Solid State Disks, Flash Memory and its applicability to DB2 and best practices.
Objective 3: Storage virtualization and its applicability to DB2 and best practices.
Objective 4: Storage replication for disaster recovery - best practices and tips.
Objective 5: Thin provisioning and wide striping - what it means to DB2, best practices and tips.
Abstract: The storage landscape keeps changing drastically and will probably continue to do so in the upcoming years. The advent of Solid State Storage (SSDs) and Flash Memory make disk latencies a thing of the past. Storage virtualization and thin provisioning add new challenges to the DBAs world. Storage replication allows for DR options that previously may not have been considered. In this session, all these storage concepts are examined in context for a DB2 DBA, with concrete suggestions and best practices for both pureScale and non-pureScale environments. This is the type of information that separates the professional DBA from mere mortals!