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 <[email protected]>
To:
[email protected]
Date:
02/24/14 03:49 PM
Subject:
[ADSM-L] ALL Tapes known to TSM
Sent by:
"ADSM: Dist Stor Manager" <[email protected]>
I've checked outputed q volhistory, there is no word about 938.
+----------------------------------------------------------------------
|This was sent by [email protected] via Backup Central.
|Forward SPAM to [email protected].
+----------------------------------------------------------------------
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.
