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 <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] On Behalf Of Orville > Lantto > Sent: Friday, March 09, 2007 12:33 PM > To: ADSM-L@VM.MARIST.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 > > [EMAIL PROTECTED] > www.glasshouse.com > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lepre, > James > Sent: Friday, March 09, 2007 11:15 AM > To: ADSM-L@VM.MARIST.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. > > >