Re: 2 3494 Tape libraries seem to have very different capacities. Any ideas?
2004-08-24 08:14:40
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Fw: 2 3494 Tape libraries seem to have very different capacities. Any ideas?, (continued)
- Fw: 2 3494 Tape libraries seem to have very different capacities. Any ideas?, John C Dury
- Re: 2 3494 Tape libraries seem to have very different capacities. Any ideas?, David E Ehresman
- Re: 2 3494 Tape libraries seem to have very different capacities. Any ideas?, John C Dury
- Re: 2 3494 Tape libraries seem to have very different capacities. Any ideas?, Richard Sims
- Re: 2 3494 Tape libraries seem to have very different capacities. Any ideas?, David E Ehresman
- Re: 2 3494 Tape libraries seem to have very different capacities. Any ideas?, David E Ehresman
- Re: 2 3494 Tape libraries seem to have very different capacities. Any ideas?, Stapleton, Mark
- Re: 2 3494 Tape libraries seem to have very different capacities. Any ideas?, David E Ehresman
- Re: 2 3494 Tape libraries seem to have very different capacities. Any ideas?, John C Dury
- Re: 2 3494 Tape libraries seem to have very different capacities. Any ideas?, Richard Sims
- Re: 2 3494 Tape libraries seem to have very different capacities. Any ideas?,
David E Ehresman <=
- Re: 2 3494 Tape libraries seem to have very different capacities. Any ideas?, John C Dury
|
|
|