We have two large TSM servers, the larger with a database on the order of 1.4TB. In the latest hardware refresh, I debated whether to buy SSDs for the database. I ended up sticking with the tried-and-true 15K SAS disks since I wasn't sure of the consequences of the high write load from DB2 on the lifespan of the SSDs.
On Tue, Mar 10, 2015 at 07:52:39AM -0600, Matthew McGeary wrote: > Hello Robert, > > We use SSD arrays for both our database and our active log. That said, > unless you are using TSM deduplication or node replication, SSD disks > should not be required for good server performance. Standard 15K SAS > drives are more than sufficient for regular server operations when dedup > and replication are not used. > > Your restore steps appear correct and should function as desired. > > Regards, > __________________________ > Matthew McGeary > Technical Specialist - Operations > PotashCorp > T: (306) 933-8921 > www.potashcorp.com > > > > > From: Robert Ouzen <[email protected]> > To: [email protected] > Date: 03/10/2015 07:28 AM > Subject: [ADSM-L] Increase performance with SSD disls > Sent by: "ADSM: Dist Stor Manager" <[email protected]> > > > > Hi to all > > To increase performance on my TSM servers 7.1.1.0 , I think to install my > databases on SSD disks. > > I have some questions: > > > Þ Will be more efficient to put the active log too on the SSD disks > > Þ Can I move in the same step the database and the active log as: > > o On dsmserv.opt change the activelogdir to the new path for SSD disk > (before I un the restore db) > > o dsmserv restore db todate=today on=dbdir.file (on dbdir.file the > new path for SSD disks) > Best Regards > > Robert > -- -- Skylar Thompson ([email protected]) -- Genome Sciences Department, System Administrator -- Foege Building S046, (206)-685-7354 -- University of Washington School of Medicine
