The Faster DB2 Performance with IBM FlashSystem IBM Redbooks Solution Guide, TIPS-1041, was published on 18 July 2013.
This solution guide explains the benefits of using IBM FlashSystem storage products with IBM DB2 databases. When you move your databases, or part of your databases, to FlashSystem storage, you can improve the performance of the entire database.
Replace slower hard disk drive (HDD) and solid state device (SSD) flash solutions with FlashSystem products to maximize transactions and I/O operations per second (IOPS).
This guide discusses how moving transaction logs, temporary table spaces, and frequently accessed tables to FlashSystem storage can improve database performance. Performance can also be improved with preferred read, a technique that mirrors an entire database or portions of the database. Data is read from fast FlashSystem storage to minimize latency and mirrored to traditional storage. Volumes can be mirrored using an IBM SAN Volume Controller or IBM AIX Logical Volume Manager (LVM).
It also describes common tools to monitor database performance, including the monreport module, snapshot monitoring, and the db2top utility. These tools provide information about monitoring elements and real-time performance monitoring techniques such as snapshots. Snapshots show the state of the database at a specific point in time.
Read this guide to learn how you can improve performance for your DB2 databases.