I always use Select volume_name from libvolumes where status='Private' and last_use is null
To get volumes that should be (maybe) scratch but aren't for some reason. Now if you have a real private volume checked in that hasn't been used yet, it will still show last_use as NULL. You need to check that the tape is really scratch and then figure out why/how it was made private. Like the tape doesn't have a label and you don't have the library as autolabel...or the tape is write-protected... To find out if a tape is really a scratch, we usually run a select on the volhistory and the last entry should be STGDELETE. Bill Boyer DSS, Inc. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David Bronder Sent: Friday, March 23, 2007 3:56 PM To: [email protected] Subject: Re: Re: Shrinking scratch pools - tips? Colwell, William F. wrote: > > I would check first for volume leaks. If this select returns anything > it is bad - > > select volume_name from libvolumes where status = 'Private' and owner > is null That's not necessarily true. If you're using a standalone TSM server (not set up as a library manager for other TSM servers), the owner field in the libvolumes table can/will be null as well. -- Hello World. David Bronder - Systems Admin Segmentation Fault ITS-SPA, Univ. of Iowa Core dumped, disk trashed, quota filled, soda warm. [EMAIL PROTECTED]
