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 <rouzen AT UNIV.HAIFA.AC DOT IL>
> To:     ADSM-L AT VM.MARIST DOT EDU
> Date:   03/10/2015 07:28 AM
> Subject:        [ADSM-L] Increase performance with SSD disls
> Sent by:        "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> 
> 
> 
> 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 (skylar2 AT u.washington DOT edu)
-- Genome Sciences Department, System Administrator
-- Foege Building S046, (206)-685-7354
-- University of Washington School of Medicine