ADSM-L

Re: 2 3494 Tape libraries seem to have very different capacities. Any ideas?

2004-08-24 08:14:40
Subject: Re: 2 3494 Tape libraries seem to have very different capacities. Any ideas?
From: David E Ehresman <deehre01 AT LOUISVILLE DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 24 Aug 2004 08:15:00 -0400
Here's another query to try:

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'))

It will list any Private tapes that are NOT in a storage pool and NOT a
db backup tape.  These tapes are essentially lost to tsm and should
returned to scratch status with an 'update libvol' command.

David