I would also check that reclamations and expirations are running as expected.

-----Original Message-----
From: ADSM: Dist Stor Manager <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU <ADSM-L AT VM.MARIST DOT EDU>
Sent: Fri Mar 23 09:57:58 2007
Subject: Re: Shrinking scratch pools - tips?

On Friday 23 March 2007, Bell, Charles (Chip) wrote:
> Since this a GREAT place for info, etc., I though I would ask for
> tips/how-to's on tracking down why my scratch pools are dwindling, for
> LTO/LTO2/VTL. My guess is I have a couple of clients that are sending out a
> vast amount of data to primary/copy. But without a good reporting tool, how
> can I tell? Expiration/reclamation runs fine, and I am going to run a check
> against my Iron Mountain inventory to see if there is anything there that
> should be here. What else would you guys/gals look at?  :-)  Thanks in
> advance!
If you want to sort filespaces by date:

select * from filespaces order by BACKUP_START


Stef

********************************************
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.

Thank you.
********************************************