The following query (thanks to a Paul Seay session at SHARE) will list tapes 
maked as PRIVATE but not in use:

select volume_name as "Private Tapes NOT in Use" -
from libvolumes -
where status='Private' -
and libvolumes.volume_name not in -
(select volume_name from volumes) -
and libvolumes.volume_name not in -
(select volume_name from volhistory -
where type in ('BACKUPFULL', -
'BACKUPINCR', -
'DBSNAPSHOT', -
'EXPORT'))

Tapes listed by the above query can be updated to SCRATCH status with an
  UPDATE LIBVOL library_name vol_name STATUS=SCRATCH

David

>>> "Lepre, James" <jlepre AT SOLIXINC DOT COM> 3/9/2007 12:35 PM >>>
I have done the first 4 steps already.. What I believe is happening is that 
when some scratch tapes were put in TSM tried to use them, couldn't and mark 
them as private.. Is there a command to check to see if this is happening 

 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Orville Lantto
Sent: Friday, March 09, 2007 12:33 PM
To: ADSM-L AT VM.MARIST DOT EDU 
Subject: Re: [ADSM-L] NO SLOTS

First, get a reliable inventory of what tapes are in your library, perhaps 
forcing the library to do an inventory beforehand.  Do not use TSM for this.

Second, reconcile the hardware inventory against what TSM reports in "q libvol" 
for this library, perhaps doing a TSM library audit beforehand.

Third, investigate the disparities.  You unavailable tapes could be out of the 
library or were made unavailable when TSM couldn't mount them because of drive 
errors or whatever.  If they are in the library and not damaged, just update 
them to readwrite.

Fourth, review your reclamation policy and procedures.

Fifth, if you still are out of slots, upgrade your tape technology, get another 
frame on your library, or eject tapes and start storing them outside your 
library.



Orville L. Lantto
Storage Consultant
 
 
GlassHouse Technologies, Inc. 
200 Crossing Boulevard
Framingham, MA 01702

orville.lantto AT glasshouse DOT com 
www.glasshouse.com 
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Lepre, James
Sent: Friday, March 09, 2007 11:15 AM
To: ADSM-L AT VM.MARIST DOT EDU 
Subject: Re: [ADSM-L] NO SLOTS

Hello Everyone,
 
 I am having problem with no available slots in my 3584 library.  I am running 
tsm 5.3.2.5 and have 450 slots in the library.  I also have over 50 unavailable 
tapes listed in TSM. I am struggling to figure out what to do first. Does 
anyone have a suggestion to where I should start to solve this problem. 
 
Thank you in advance
 
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.