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
