Re: Cleaning up "lost" tapes....

This is TMS on z/OS.   There is no such thing as a "checkin" process for
tapes. The OS does this automatically (cant say that about any other TSM
platform!).

I guess I should have clarified. I did a SELECT/QUERY of *1* tape from
VOLHIST, using STGDEL. One of these "lost" tapes should up 8-times !.

This brings up another question. There are entries in my VOLHIST going
back to 1997.  Should I be clearing these out, somehow, using a standard
administrative schedule, like I do with my DBBACKUP volumes ?





"Prather, Wanda" <Wanda.Prather AT JHUAPL DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
08/20/2003 01:19 PM
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: Cleaning up "lost" tapes....


Some ideas:

1) Try to check them in as scratch.  TSM will not let you do that if the
tape exists anywhere in in a storage pool OR in volumehistory.

2) Don't navigate the volhistory, SELECT!

Presumably when you were using the 3490's, they had a unique devclass, so
try this:

Select * from volhistory where devclass='3490DEVCLASS' and type not in
('STGNEW','STGREUSE','STGDELETE')

How's that?!?

-----Original Message-----
From: Zoltan Forray/AC/VCU [mailto:zforray AT VCU DOT EDU]
Sent: Wednesday, August 20, 2003 11:20 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Cleaning up "lost" tapes....


I am going through a cleanup process on my z/OS system tape library.

Long ago, were started using TSM (ADSM) with 3490 cartridges.   We stopped
using 3490 tapes, long ago.

However, running through my CA-1 database, I found hundreds of 3490 tapes,
still locked and showing ADSM3490.* as the dataset names and the
owner/writer as ADSM.

Yet, checking a few entries (Q VOL xxxxxx), ADSM/TSM disavows any
knowledge of these tapes.

I think this was caused by issues with the tape management exit / CA-1
parms.

My question is this.  How can I be absolutely sure that TSM has *NOTHING*
on these tapes so that I can forcefully scratch/release them from CA-1
control ?

Is Q VOL good enough ?

I realize that Q VOL does not show things like EXPORT tapes (which I
always felt it should........IMHO, Q VOL should show *ALL* volumes that
TSM knows about !!!!)

Also, trying to navigate through Q VOLHIST can be a pain (how many times
is a tape acquired/released/acquired/released.....)