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
