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

    View Printable Version

    Database I/O in the Brave New World

    Session Number: 2194
    Track: DB2 9.7 for LUW (C)
    Session Type: Podium Presentation
    Primary Presenter: Aamer Sachedina [IBM Toronto Lab]

    Aquarius => Thu, Nov 17, 2011 (09:45 AM - 10:45 AM)

    Speaker Bio: Aamer Sachedina is an IBM Senior Technical Staff Member and pureScale architect. Aamer has concentrated on active-active high availability of pureScale. Aamer is a veteran of the DB2 Kernel - having worked at the IBM Toronto Lab on the DB2 Kernel for 12 years. Prior to his work on pureScale, he was responsible for architecting features such as; Automatic Storage, asynchronous page cleaning, block based buffer pools, and dynamic buffer pool resize. Aamer lives with his wife Jen and two boys, Hayden and Julian on a hobby farm north of the Toronto Lab where he breeds Scottish Galloway cattle and trains his Belgian Malinois in Schutzhund.
    Audience experience level: Beginner, Intermediate, Advanced
    Presentation Category: Implementing New DB2 Releases and Features
    Presentation Platform: Select a Value
    Audiences this presentation will apply to: Data Architects, Database Administrators, IT Managers
    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: Introduction to the storage universe in the enterprise. Past, present and future trends.
    Objective 2: NAS and SAN basics and how they are evolving and the effect on the data center and database systems. Emerging technologies; FCoE etc.
    Objective 3: SSDs and flash storage, virtualization in the storage world, wide striping and VIOS
    Objective 4: Concrete storage best practices for DB2 ESE - extent sizes, prefetch sizes, DB2_PARALLEL_IO and how to set these given your backend storage.
    Objective 5: Concrete storage best practices for DB2 pureScale including GPFS.

    Abstract:  Enterprise storage has undergone and continues to undergo substantial changes from locally attached disks to SAN and NAS and ever increasing forms of IO virtualization. In this session we will examine the different types of enterprise storage technologies that are prevalent and emerging and understand the best practices for their applicability to database I/O and storage in DB2. SAN, NAS, VIOS, thin provisioning, SSDs and flash storage - what do these all mean for your database storage paths, tablespace containers and transaction logs in DB2 and DB2 pureScale? Expect these and other questions to be answered. Expect to be prepared for the brave new world of I/O and storage!

    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