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

Sorry, I forgot you were z/OS; you could probably accomplish the same thing
by trying to define a volume to the storage pool, but that's a lot of work.

The query should still work; it EXCLUDES the STGNEW/STGDEL/STGREUSE entries;
you don't CARE about those.
You don't need to check how many times it got created then deleted.
If it isn't in the stgpool NOW, there's no stgpool data on it.

The query against volhistory will tell you if there is still a DB BACKUP, or
BACKUPSET, EXPORT, or other non-stgpool tape still active in volhistory.

If a volume doesn't show up in either place, there's no good data on it.

-----Original Message-----
From: Zoltan Forray/AC/VCU [mailto:zforray AT VCU DOT EDU]
Sent: Wednesday, August 20, 2003 1:32 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: 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.....)