Faster DB2 Performance with IBM FlashSystem Solution Guide
Megan_Gilge 06000101S8 Visits (2011)
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).