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.
