One would only have to "select * from volhistory" to determine what the type 
name is for backupsets and add it to the list in the last part of the query.  I 
don't have backupsets in my volhistory so I can't check.

David

>>> Steven Harris <steve AT STEVENHARRIS DOT INFO> 3/12/2007 7:42 PM >>>
Paul hasn't been around here for a few years now.  I wonder if this
query would need to be adjusted for backupsets?

Steve

Steven Harris
AIX and TSM Admin
Brisbane Australia

David E Ehresman wrote:
> 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.
>
>
>