Hi all,
TSM 5.1.x.x, W2k
can sombody make sense ot of the output of the following select statment?

select a.library_name,a.volume_name,a.status,a.last_use from libvolumes a
where a.status='Private' and (a.last_use <>'DbBackup' or a.last_use is Null)
and not exists(select b.volume_name from volumes b where
a.volume_name=b.volume_name)
OUTPUT
LIBRARY_NAME           VOLUME_NAME            STATUS         LAST_USE
------------------     ------------------     ----------     ----------
ADIC100                000023L1               Private        Data
ADIC100                000039L1               Private
ADIC100                000074L1               Private        Data

The volume 000039l1 had an I/O error on the label, wich is OK, but the other 2
don't make sense.
Checkout / checkin status=scratch assigns volume status scratch, update libv
status=scr as well.
These volumes never disappear.

Best Regards

Markus Veit