Hey, Nick, missed your name the first time around! Being in higher-ed/research we went the cheap route and actually just use direct-attach 15K SAS drives on Dell servers, divvied up into multiple RAID-10 sets. Even a 1TB database only takes us ~1 hour to backup or restore, which is well within our SLA.
On 12/20/2013 11:42 AM, Marouf, Nick wrote: > Hi Skylar ! > > Yes that would be the easy way do it, there is an option to rebalance > the I/O after you add the new file systems to the database. I had already > setup TSM before the performance tuning guideline was released. Doing this > way, will require more storage initially and running db2 rebalancing command > line tools will spread out the DB I/O load > > Using IBM XIV's that can handle very large IO requests, in our specific > case there was no need to provide physically-separate volumes. I've seen one > TSM instance crank upwards of 10,000 IOPS leaving an entire ESX cluster in > the dust. -- -- Skylar Thompson (skyl...@u.washington.edu) -- Genome Sciences Department, System Administrator -- Foege Building S046, (206)-685-7354
