Re: [ADSM-L] unaccounted for volumes
2012-10-08 08:42:14
Here is a script that I got at a Share conference years ago that lists tapes
that are marked Private but are not being used:
tsm: ULTSM>q script q_lost_tapes f=l
Name Line Command
Number
---------- ------ ------------------------------------------------------------
Q_LOST_TA- 10 select volume_name as "Private Tapes NOT in Use" -
PES
20 from libvolumes -
30 where status='Private' -
40 and libvolumes.volume_name not in -
50 (select volume_name from volumes) -
60 and libvolumes.volume_name not in -
80 (select volume_name from volhistory -
90 where type in ('BACKUPFULL', -
100 'BACKUPINCR', -
110 'DBSNAPSHOT', -
120 'EXPORT'))
tsm: ULTSM>
I update such tapes to status Scratch.
David Ehresman
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Lee, Gary
Sent: Friday, October 05, 2012 2:36 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] unaccounted for volumes
Tsm server 6.2.2 running on RHEL v6 with a 3494 library and 8 ts1120 drives.
Was doing some checking on tape inventory and usage for one of our tsm servers.
A
Select count(*) from libvolumes
Shows 298 volumes in the library.
Checking volhistory for database backup volumes shows 3 tapes in that capacity.
Check of pending volumes shows 1
And summing up all tape pool volumes gives 118.
A
Select count(*) from libvolumes where status='Private'
Shows 160
And
Select for scratch volumes gives 137.
The upshot is that I have around 40 volumes in the libvolumes table listed as
private, but not accounted for in the volumes or volhistory?
Audit library ields no errors.
Can I just check these out and re check them in as scratch?
What would account for this.
p.s.
I have the volhist file from the moment the server was placed online. The lost
volumes do not appear there anywhere.
Thanks for any help.
Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [ADSM-L] unaccounted for volumes, Lee, Gary
- Re: [ADSM-L] unaccounted for volumes, Vandeventer, Harold [BS]
- Re: [ADSM-L] unaccounted for volumes, Bob Levad
- Re: [ADSM-L] unaccounted for volumes, Steven Langdale
- Re: [ADSM-L] unaccounted for volumes,
Ehresman,David E. <=
- [ADSM-L] MAC Agent hanging, Huebner,Andy,FORT WORTH,IT
|
|
|