That's been my suspicion of how tapes wind up as private without a stgpool. So I run this periodically (with a tip of the hat to Paul Seay).
select volume_name from libvolumes where
status='Private' and libvolumes.volume_name
not in (select volume_name from volumes) and
libvolumes.volume_name not in (select
volume_name from volhistory where type in
('BACKUPFULL','BACKUPINCR','DBSNAPSHOT','EXPO-
RT'))At 10:56 AM 6/5/2003 -0400, you wrote:
Thanks for the q libr command found out that 400 is my private category. When I look in my act log I find no references to these volumes & they do not show up in q vol or q libv. Any suggestions about there real status? Could they be volumes that were mounted in a drive when TSM went down? Also I tried to check them in they failed on reading the label! I guess my question is does anybody any reason to NOT recheck them in as scratch & overwrite the existing label? Did I miss someplace else to check the status of these tapes with TSM?
Thanks, -------------------------------------- Bruce Kamp Midrange Systems Analyst II Memorial Healthcare System E: [EMAIL PROTECTED] P: (954) 987-2020 x4597 F: (954) 985-1404 ---------------------------------------
