Re: [ADSM-L] unaccounted for volumes
2012-10-08 13:31:55
In a library sharing environment, I think this will flag volumes that
are associated with a different TSM server as orphaned. This is the
script I've been using:
tsm: TIBUR>q scr find_orphan_vols f=r
SELECT lv.volume_name from libvolumes lv -
LEFT OUTER JOIN volumes v ON lv.volume_name=v.volume_name -
LEFT OUTER JOIN volhistory vh ON lv.volume_name=vh.volume_name -
WHERE v.volume_name IS NULL -
AND vh.volume_name IS NULL -
AND lv.status<>'Scratch' -
AND lv.status<>'Cleaner'
-- Skylar Thompson (skylar2 AT u.washington DOT edu)
-- Genome Sciences Department, System Administrator
-- Foege Building S046, (206)-685-7354
-- University of Washington School of Medicine
On 10/ 8/12 05:38 AM, Ehresman,David E. wrote:
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.
- Re: [ADSM-L] unaccounted for volumes,
Skylar Thompson <=
- [ADSM-L] MAC Agent hanging, Huebner,Andy,FORT WORTH,IT
|
Previous by Date: |
Re: [ADSM-L] unaccounted for volumes, Ehresman,David E. |
Next by Date: |
[ADSM-L] Nodes per TSM server, Vandeventer, Harold [BS] |
Previous by Thread: |
Re: [ADSM-L] unaccounted for volumes, Ehresman,David E. |
Next by Thread: |
[ADSM-L] MAC Agent hanging, Huebner,Andy,FORT WORTH,IT |
Indexes: |
[Date]
[Thread]
[Top]
[All Lists] |
|
|