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