Long ago (it seems) someone gave me this select statement...I used to have to run it on a weekly basis on my stuffed library:
select volume_name , status from libvolumes where status='Private' and volume_name not in (select volume_name from volumes) and volume_name not in (select volume_name from volhistory where type not in('STGNEW','STGREUSE','STGDELETE') ) tsm: ADSM1>select volume_name , status from libvolumes where status='Private' and volume_name not in (select volume_name from volumes) and volume_name not in (select volume_name from volhistory where type not in('STGNEW','STGREUSE','STGDELETE') ) VOLUME_NAME STATUS ------------------ ---------------- CE Private VOLZ114 Private VOLZ297 Private VOLZ298 Private VOLZ299 Private VOLZ455 Private VOLZ720 Private tsm: ADSM1> It is interesting that I have three consecutive tapes made private. There is also a service tape in with the data tapes. - You can also check for events recent enough that they still reside in the actlog by looking for this Warning message,ANR8778W: q actlog begind=-10 msgno=8778 help ANR8778W ANR8778W Scratch volume volume name changed to Private Status to prevent re-access. Not sure if someone mentioned that if the tape is not labeled internally, it will keep going back to "private" whenever TSM tries to use it. George Huebschman (George H.) From: r4mzeso <tsm-fo...@backupcentral.com> To: ADSM-L@VM.MARIST.EDU Date: 02/24/14 03:49 PM Subject: [ADSM-L] ALL Tapes known to TSM Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> I've checked outputed q volhistory, there is no word about 938. +---------------------------------------------------------------------- |This was sent by r4mz...@gmail.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +---------------------------------------------------------------------- The contents of this email are the property of PNC. If it was not addressed to you, you have no legal right to read it. If you think you received it in error, please notify the sender. Do not forward or copy without permission of the sender. This message may contain an advertisement of a product or service and thus may constitute a commercial electronic mail message under US Law. The postal address for PNC is 249 Fifth Avenue, Pittsburgh, PA 15222. If you do not wish to receive any additional advertising or promotional messages from PNC at this e-mail address, click here to unsubscribe. https://pnc.p.delivery.net/m/u/pnc/uni/p.asp By unsubscribing to this message, you will be unsubscribed from all advertising or promotional messages from PNC. Removing your e-mail address from this mailing list will not affect your subscription to alerts, e-newsletters or account servicing e-mails.