Re: Re: Re: TSM script for the number of tape mounts per tape volume

2016-07-28 Thread David Bronder
> Sent: Thursday, July 28, 2016 11:11 AM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] Re: TSM script for the number of tape mounts per tape > volume > > Charles, > > Note that this number may not mean what you expect it to. The help for > "query volume&qu

Re: Re: TSM script for the number of tape mounts per tape volume

2016-07-28 Thread Lamb, Charles P.
Subject: Re: [ADSM-L] Re: TSM script for the number of tape mounts per tape volume **WARNING** This message originated outside of NPPD. DO NOT click on any links or attachments unless you have confirmed that it is from a trusted sender

Re: Re: TSM script for the number of tape mounts per tape volume

2016-07-28 Thread David Bronder
Charles, Note that this number may not mean what you expect it to. The help for "query volume" notes that this value is the number of times the server opened the volume, which may be more than once per physical mount. Also, if you use scratch tapes, I'm pretty sure that the value gets discarded

Re: Re: TSM script for the number of tape mounts per tape volume

2016-07-28 Thread Lee, Gary
Yes, mount count resets to zero when it returns to scratch. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David Bronder Sent: Thursday, July 28, 2016 11:11 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Re: TSM script for the number

Re: TSM script for the number of tape mounts per tape volume

2016-07-28 Thread Koos Rietveld
select char(volume_name, 30) as VOLUME_NAME, times_mounted from volumes where stgpool_name='VDP-DAT' order by times_mounted desc Kind regards/Cordialement/Mit freundlichen Grüßen/Met vriendelijke groet Koos Rietveld Senior Network/System/Storage Administrator Contract Logistics Northern