I too am confused, not that that is so unusual. I am not sure I
understand what you are saying.
There are offsite volumes, but no copypool. So, the (physically ?)
offsite volumes are in the primary pool hierarchy? Is that the case?
If so, and reclamation is really what is going on, then it is simply
whatever volumes are above the reclamation threshold you have decided
on. The select below shows you what you want.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Howard Coles
Sent: Tuesday, February 24, 2009 4:24 PM
To: ADSM-L AT VM.MARIST DOT EDU
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: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
IMPORTANT: E-mail sent through the Internet is not secure and timely delivery
of Internet mail is not guaranteed. Legg Mason therefore, recommends that you
do not send any action-oriented or time-sensitive information to us via
electronic mail, or any confidential or sensitive information including:
social security numbers, account numbers, or personal identification numbers.
This message is intended for the addressee only and may contain privileged or
confidential information. Unless you are the intended recipient, you may not
use, copy or disclose to anyone any information contained in this message. If
you have received this message in error, please notify the author by replying
to this message and then kindly delete the message. Thank you.
|
