Faster DB2 Performance with IBM FlashSystem

Abstract

This IBM® Redbooks® Solution Guide provides an overview of IBM FlashSystem™ running in a DB2® environment with a focus on performance and the benefits gained from running DB2 with Flash storage.

I/O performance is critical to DB2 operations. Although you can improve performance by using faster processors, faster systems, and advanced DB2 capability, data must still be read from and written to storage. Traditional hard disk drive (HDD) storage cannot provide the speed that is required by many applications. Many solid-state device (SSD) solutions add latency because software is required to manage access to flash storage and access can take several milliseconds (ms).

IBM FlashSystem products provide extremely fast external storage, with low latency of approximately 90 μs write time and 135 μs read time. You can move your most I/O-intensive operations to FlashSystem storage for an immediate increase in performance, while reducing costs for power, cooling, and administration.

Contents


This IBM® Redbooks® Solution Guide provides an overview of IBM FlashSystem™ running in a DB2® environment with a focus on performance and the benefits gained from running DB2 with Flash storage. I/O performance is critical to DB2 operations. Although you can improve performance by using faster processors, faster systems, and advanced DB2 capabilities, data must still be read from and written to storage.

Continue reading full document

Special Notices

This material has not been submitted to any formal IBM test and is published AS IS. It has not been the subject of rigorous review. IBM assumes no responsibility for its accuracy or completeness. The use of this information or the implementation of any of these techniques is a client responsibility and depends upon the client's ability to evaluate and integrate them into the client's operational environment.

Contact an IBM Sales Specialist


Profile

Publish Date
18 July 2013

Last Update
21 July 2014


Rating:
(based on 4 reviews)


Author(s)

IBM Form Number
TIPS1041