Hi Dwight,

"query content vol_ser" will show all valid ie unexpired files on the
tape. What I want to know is which of those files are active ie "latest
backup, not deleted on client" files.

It seems that Reinhard my be right that there is no way to determine
this. It would be better if I could go back to the owners of the
affected systems and give them more detail then 'we lost some of your
files; here are the names but we can't tell you anything else like when
they were backed up, etc.'.


Trevor

> -----Original Message-----
> From: Dwight Cook [SMTP:decook AT AMOCO DOT COM]
> Sent: Wednesday, 20 May 1998 1:09 am
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: Chewed 3590 cartridge
>
>      Actually if you simply do a "query content vol_ser" you will only
> see
>      the active files left on the tape...
>
>
> ______________________________ Reply Separator
> _________________________________
> Subject: Re: Chewed 3590 cartridge
> Author:  mersch (mersch AT UNI-MUENSTER DOT DE) at unix,mime
> Date:    5/19/98 2:02 AM
>
>
> Hi,
>
> we lost three 3590 tapes due to "ANR8359E Media fault detected ...".
> The
> tapes always belonged to storage pools, which we do not back up. So
> all I
> did was to delete the volumes (DISCARDDATA=YES), informed the affected
> users and urged them to do an incremental.
>
> These things happened when we were on V.2. I did not see any
> possibility
> to determine, whether the affected backups were active or not. So I
> decided to not worry about it. (What else could I do, if I were able
> to
> identify the inactive copies?)
>
> An interesting question is, whether the SQL interface of V.3 allows us
> to identify inactive copies on a storage pool volume. A quick look at
> the SQL table layout does not give me any clue :-(
> Maybe the DEACTIVATE_DATE in the BACKUPS table gives the wanted
> information, but how do I get the connection from an entry in the
> CONTENTS table to the corresponding entry in the BACKUPS table? Any
> ideas?
>
> --
> Reinhard Mersch                     Westfaelische
> Wilhelms-Universitaet
> Universitaetsrechenzentrum, Roentgenstrasse 13, 48149 Muenster,
> Germany
> E-Mail: mersch AT uni-muenster DOT de                  Phone:
> +49(251)83-31583
>
> Trevor Foley writes:
>  > Hi,
>  >
>  > One of our 3590 drives decided that is was hungry the other day,
> and
>  > made a meal out of one of our cartridges. I can do a query content
> of
>  > the volume and get a list of files (~13,000 of them). How do I
> determine
>  > when each of these files was backed up, whether they are active or
> not,
>  > etc. We do not have copy pools for this storage pool, otherwise I
> would
>  > just mark the volume as destroyed and restore the data from the
> copy
>  > pool.
>  >
>  > But what I need to work out is what we have lost. For the files
> that are
>  > on that volume and active, again it isn't a problem, because if I
>  > deleted all of the files on the volume, the active ones would be
> backed
>  > up again next incremental backup. It is the non-active ones that I
> am
>  > concerned about.
>  >
>  > Has anyone else had a 3590 cartridges chewed? Due to this problem,
> and a
>  > few others of the past few months, we are reviewing our decision
> not to
>  > implement copy pools.
>  >
>  >
>  > Trevor
>  >
> ----------------------------------------------------------------------
> --
>  > ------------------------------------------------
>  > Trevor Foley
>  > Bankers Trust Australia Limited
>  > Phone: 61-2-9259 3944    Fax: 61-2-9259 2659