Re: How to check utilization of your storagepools automaticly
Interesting... Does ServerGraph belong to the TSM software or where can I get it ? Kind Regards Martina Sawatzki
Re: How to check utilization of your storagepools automaticly
Servergraph is very good, but too pricey for us as we only have 25 client machines. I wanted it but the boss said no :( You can check it out here http://www.servergraph.com/ Thanks Farren Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: Re: How to check utilization of your storagepools automaticly Interesting... Does ServerGraph belong to the TSM software or where can I get it ? Kind Regards Martina Sawatzki
How to check utilization of your storagepools automaticly
Hi I need a way to check my tapepools when to add more scratch and my diskpools to add more disc's? /Regards Niklas
Re: How to check utilization of your storagepools automaticly
Hi select count(*) from libvolumes where status='Scratch' will return the number of available scratch volumes The above is not applicable when using Gresham EDT. In this case, you will need to use cmdproc -l q pool pool number(usually 7 with gresham) to show the number available scratch volumes. select stgpool_name, pct_utilized from stgpools where pct_utilized 80 will return all stgpools that have a utilization above 80%. If you are using a UNIX-based server, you can issue the above TSM commands with dsmadmc, and then pipe it into a mail using commandmail -s Status reciepients Best Regards Daniel Sparrman --- Daniel Sparrman Exist i Stockholm AB Propellervägen 6B 183 62 HÄGERNÄS Växel: 08 - 754 98 00 Mobil: 070 - 399 27 51 Nilsson Niklas [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 2003-01-09 15:38 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:How to check utilization of your storagepools automaticly Hi I need a way to check my tapepools when to add more scratch and my diskpools to add more disc's? /Regards Niklas
Re: How to check utilization of your storagepools automaticly
Q libvol will show you how many scratch tapes you have in your library. -- Joshua S. Bassi IBM Certified - AIX 4/5L, SAN, Shark Tivoli Certified Consultant -ADSM/TSM eServer Systems Expert -pSeries HACMP AIX, HACMP, Storage, TSM Consultant Cell (831) 595-3962 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Nilsson Niklas Sent: Thursday, January 09, 2003 6:39 AM To: [EMAIL PROTECTED] Subject: How to check utilization of your storagepools automaticly Hi I need a way to check my tapepools when to add more scratch and my diskpools to add more disc's? /Regards Niklas
Re: How to check utilization of your storagepools automaticly
.. Have you tried running q libvol on a STK 9310 Powderhorn, and then manually counting the scratch volumes...? :=) Best Regards Daniel Sparrman --- Daniel Sparrman Exist i Stockholm AB Propellervägen 6B 183 62 HÄGERNÄS Växel: 08 - 754 98 00 Mobil: 070 - 399 27 51
Re: How to check utilization of your storagepools automaticly
Does anybody know where I can find a description of the data found in the dsmaccnt.log. I do have a feeling that I found what I was looking for for a long time. (statistics of what my SQL nodes are backing up). Thanks -Original Message- From: Cook, Dwight E [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 8:57 AM To: [EMAIL PROTECTED] Subject: Re: How to check utilization of your storagepools automaticly That isn't easy to answer... here is my 2 cents worth... For tape pools, you really need to track utilization over a period of time. Look for how much data is added daily, how much might be going away, how much expires off each tape, do tapes readily become available via reclamation or do you end up with lots of tapes at 60% util for extended periods of time. I set up little jobs to provide me information like Thu Jan 9 06:05:17 CST 2003 You have 199 SCRATCH and 1256 PRIVATE volumes of which 15 are filling, the rest are full. on a daily basis for all the TSM servers here... In a unix environment this is just an echo command with a bunch of dsmadmc -id=blah -pass=blah q libvol | grep Scratch | wc -l dsmadmc -id=blah -pass=blah q libvol | grep Private | wc -l dsmadmc -id=blah -pass=blah q vol stat=filling | grep Filling | wc -l After you track things for a while you can determine at what rate tapes are consumed and when you will need more. Same sort of thing applies to the diskpool(s). If you push to diskpools and then migrate to tape, in general you will want at least as much total diskpool space as you take in data on a nightly basis... dsmaccnt.log records are good for this sort of information. So I don't believe one can totally automate things BUT I do have a lot of info sent to me automatically for review on a daily or monthly basis... Dwight -Original Message- From: Nilsson Niklas [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 8:39 AM To: [EMAIL PROTECTED] Subject: How to check utilization of your storagepools automaticly Hi I need a way to check my tapepools when to add more scratch and my diskpools to add more disc's? /Regards Niklas
Re: How to check utilization of your storagepools automaticly
At 16:05 +0100 1/9/03, Daniel Sparrman wrote: select stgpool_name, pct_utilized from stgpools where pct_utilized 80 will return all stgpools that have a utilization above 80%. But be aware that pct_utilized can be misleading for tape pools. We had a storage pool were volumes in use had hit the max_scratch value, so it wouldn't accept any more data, but pct_utilized was around 80%. I think it's because pct_utilized is reduced when files are deleted, creating empty spaces on tapes, even though the space isn't usable. If you rely on that percentage to warn you when you need to add scratch tapes, you might get bit like we did. Use one of the sample scripts that other people have posted here that actually counts the volumes in the storage pool and lists that count along with the max scratch count. -- Matt Simpson -- OS/390 Support 219 McVey Hall -- (859) 257-2900 x300 University Of Kentucky, Lexington, KY 40506 mailto:[EMAIL PROTECTED] mainframe -- An obsolete device still used by thousands of obsolete companies serving billions of obsolete customers and making huge obsolete profits for their obsolete shareholders. And this year's run twice as fast as last year's.
Re: How to check utilization of your storagepools automaticly
It is found in the admin guide manual for the server for your platform... Unix layout is for TSM 4.2 is...(as found in the IBM/Tivoli manual) Field Contents 1 Product version 2 Product sublevel 3 Product name, 'ADSM', 4 Date of accounting (mm/dd/) 5 Time of accounting (hh:mm:ss) 6 Node name of TSM client 7 Client owner name (UNIX) 8 Client Platform 9 Authentication method used 10 Communication method used for the session 11 Normal server termination indicator (Normal=X'01', Abnormal=X'00') 12 Number of archive store transactions requested during the session 13 Amount of archived files, in kilobytes, sent by the client to the server 14 Number of archive retrieve transactions requested during the session 15 Amount of space, in kilobytes, retrieved by archived objects 16 Number of backup store transactions requested during the session 17 Amount of backup files, in kilobytes, sent by the client to the server 18 Number of backup retrieve transactions requested during the session 19 Amount of space, in kilobytes, retrieved by backed up objects 20 Amount of data, in kilobytes, communicated between the client node and the server during the session 21 Duration of the session, in seconds 22 Amount of idle wait time during the session, in seconds 23 Amount of communications wait time during the session, in seconds 24 Amount of media wait time during the session, in seconds 25 Client session type. A value of 1 or 4 indicates a general client session. A value of 5 indicates a client session that is running a schedule. 26 Number of space-managed store transactions requested during the session 27 Amount of space-managed data, in kilobytes, sent by the client to the server 28 Number of space-managed retrieve transactions requested during the session 29 Amount of space, in kilobytes, retrieved by space-managed objects 30 Product release 31 Product level Dwight E. Cook Software Application Engineer III Science Applications International Corporation 509 S. Boston Ave. Suite 220 Tulsa, Oklahoma 74103-4606 Office (918) 732-7109 -Original Message- From: Macmurray, Andrea (CAG-CC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 9:54 AM To: [EMAIL PROTECTED] Subject: Re: How to check utilization of your storagepools automaticly Does anybody know where I can find a description of the data found in the dsmaccnt.log. I do have a feeling that I found what I was looking for for a long time. (statistics of what my SQL nodes are backing up). Thanks -Original Message- From: Cook, Dwight E [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 8:57 AM To: [EMAIL PROTECTED] Subject: Re: How to check utilization of your storagepools automaticly That isn't easy to answer... here is my 2 cents worth... For tape pools, you really need to track utilization over a period of time. Look for how much data is added daily, how much might be going away, how much expires off each tape, do tapes readily become available via reclamation or do you end up with lots of tapes at 60% util for extended periods of time. I set up little jobs to provide me information like Thu Jan 9 06:05:17 CST 2003 You have 199 SCRATCH and 1256 PRIVATE volumes of which 15 are filling, the rest are full. on a daily basis for all the TSM servers here... In a unix environment this is just an echo command with a bunch of dsmadmc -id=blah -pass=blah q libvol | grep Scratch | wc -l dsmadmc -id=blah -pass=blah q libvol | grep Private | wc -l dsmadmc -id=blah -pass=blah q vol stat=filling | grep Filling | wc -l After you track things for a while you can determine at what rate tapes are consumed and when you will need more. Same sort of thing applies to the diskpool(s). If you push to diskpools and then migrate to tape, in general you will want at least as much total diskpool space as you take in data on a nightly basis... dsmaccnt.log records are good for this sort of information. So I don't believe one can totally automate things BUT I do have a lot of info sent to me automatically for review on a daily or monthly basis... Dwight -Original Message- From: Nilsson Niklas [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 8:39 AM To: [EMAIL PROTECTED] Subject: How to check utilization of your storagepools automaticly Hi I need a way to check my tapepools when to add more scratch and my diskpools to add more disc's? /Regards Niklas