What tools do you have? Do you have SAS SAS/MXG SAS/MICS, Omegamon (Tivoli), DISK Magic, etc...
What version of z/OS, DB2? What hardware is used? EMC (VMAX, other), HDS, IBM? RMF which creates the Type 70 records, should contain some of the information you are looking for. Do you have experience in Performance analysis? If you do, what tools do you normally use? What will you be using for tiering? Each hardware vendors have their own tiering solutions. I think DISK magic (fee product) by Intellimagic can do what if analysis. My understanding is that Tiering is used to move less active data to slower devices inside a storage array and put highly accessed data on faster devices in the array. That tiering is used to smooth out the hot spots in the array itself. Or move data from more expensive storage (SSD) to less expensive (SATA) devices within the array. So is your issue hot spots in the array and DB2 requires better performance (1 ms or less per transaction)? Are you mixing SSD to SATA type devices and want to ensure high access data is on the fast device? What is the problem you are trying to solve with SSD drives? Do you use DFHSM and DFSMS to manage your storage? Do you have a mixed DFSMS pool with both Spinning and SSD disks? Is the SMS pool a pure DB2 table pool or share with non-VSAM? Are your DB2 Tables currently on SSD or spinning disks? Or on mixed devices? Do you use your Storage groups to direct your DB2 tables to SSD? Lizette -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of K Sent: Wednesday, August 07, 2013 1:28 AM To: [email protected] Subject: SSD tiering benefits Dear Listers, We are thinking to implement storage tiering using some SSD volumes for some of our very active DB2 tablespaces. Is there any way to measure performance improvements for both CPU and IO utilization? Do you have any experience on tiering with SSD in DB2 environment? Kind regards Kostas ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
