View Printable Version
Database I/O in the Brave New World
DB2 9.7 for LUW (C)
Aamer Sachedina [IBM Toronto Lab]
Aquarius => Thu, Nov 17, 2011 (09:45 AM - 10:45 AM)
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
Implementing New DB2 Releases and Features
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
Introduction to the storage universe in the enterprise. Past, present and future trends.
NAS and SAN basics and how they are evolving and the effect on the data center and database systems. Emerging technologies; FCoE etc.
SSDs and flash storage, virtualization in the storage world, wide striping and VIOS
Concrete storage best practices for DB2 ESE - extent sizes, prefetch sizes, DB2_PARALLEL_IO and how to set these given your backend storage.
Concrete storage best practices for DB2 pureScale including GPFS.
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!