I am confusing. What i am trying to say is I know the tape being reclaimed but that tape need other tapes to pull files from simce it is non collocated. Am i making sense
----- Original Message ----- From: ADSM: Dist Stor Manager <ADSM-L@VM.MARIST.EDU> To: ADSM-L@VM.MARIST.EDU <ADSM-L@VM.MARIST.EDU> Sent: Tue Feb 24 16:24:03 2009 Subject: Re: [ADSM-L] Select Statement Hmm. I'm confused. IF you don't have a copy pool then the volume required for reclamation is the volume, or volumes that are set to be reclaimed. A good way to find out which volumes need reclamation is: select volume_name as TAPEPOOL_VOL,est_capacity_mb as CAPACITY,pct_utilized as UTILIZATION,pct_reclaim as RECLAIMABLE from volumes where stgpool_name='TAPEPOOLNAME' and pct_reclaim>=60 order by pct_reclaim desc Now if you want to put this in a script replace the "pct_reclaim>=60" part with "pct_reclaim>=%1" and use the first parameter to define what level of reclamation you're looking for. You'll also need to replace the "TAPEPOOL" references with the pool(s) you have. This will print out a list something along the lines of: TAPEPOOL_VOL CAPACITY UTILIZATION RECLAIMABLE ------------------ -------------------- ----------- ----------- 010389 381468.0 4.3 95.6 011392 381468.0 4.3 95.6 011146 381468.0 21.3 78.6 010209 381468.0 24.7 75.2 011278 381468.0 42.0 57.9 However, I would highly recommend a copy pool even with a VTL (unless you're doing VTL to VTL replication to another site). See Ya' Howard > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf > Of Lepre, James > Sent: Tuesday, February 24, 2009 3:01 PM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] Select Statement > > Well The reason I am asking is that we do not have a copypool setup for > our offsite tapepool since we are using a VTL. However, the physical > library is small and some of the tapes needed to reclaim may not be in > the system. If I can generate a list of tapes needed to reclaim a > certain volume then I can check all of those volumes in and let it do > its thing, instead of constantly checking to see if it needs another > tape > > James Lepre > Senior Server Specialist > Solix Inc > 100 South Jefferson Road > Whippany NJ 07981 > Phone 1-973-581-5362 > Cell 1-973-223-1921 > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf > Of > Remco Post > Sent: Tuesday, February 24, 2009 3:55 PM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] Select Statement > > Interesting question. > > Why would you want to know? I hope your primary volumes are all on- > line? > > On Feb 24, 2009, at 21:48 , Lepre, James wrote: > > > Hello Everyone, > > > > > > > > Is there a select statement or preview to see which tapes will be > > needed to reclaim an offsite volume. > > > > > > > > Thank you > > > > > > > > James > > > > > > > > > > > > > > > > > > --------------------------------------------------------------- > > Confidentiality Notice: The information in this e-mail and any > > attachments thereto is intended for the named recipient(s) only. > > This e-mail, including any attachments, may contain information that > > is privileged and confidential and subject to legal restrictions > > and penalties regarding its unauthorized disclosure or other use. > > If you are not the intended recipient, you are hereby notified that > > any disclosure, copying, distribution, or the taking of any action > > or inaction in reliance on the contents of this e-mail and any of > > its attachments is STRICTLY PROHIBITED. If you have received this e- > > mail in error, please immediately notify the sender via return e- > > mail; delete this e-mail and all attachments from your e-mail > > system and your computer system and network; and destroy any paper > > copies you may have in your possession. Thank you for your > > cooperation. > > -- > Met vriendelijke groeten, > > Remco Post > r.p...@plcs.nl > +31 6 248 21 622