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:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of Lepre, James
> Sent: Tuesday, February 24, 2009 3:01 PM
> To: ADSM-L AT VM.MARIST DOT 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:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of
> Remco Post
> Sent: Tuesday, February 24, 2009 3:55 PM
> To: ADSM-L AT VM.MARIST DOT 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.post AT plcs DOT nl
> +31 6 248 21 622