ADSM-L

Re: Chewed 3590 cartridge

1998-05-20 20:22:46
Subject: Re: Chewed 3590 cartridge
From: Trevor Foley <Trevor.Foley AT BANKERSTRUST.COM DOT AU>
Date: Thu, 21 May 1998 10:22:46 +1000
Hi Rejean,

Thanks for the SELECT command. I suspected that I might have been able
to do something like that, other than for the fact that this particular
server is still running V2. But I will file your command away for future
reference.


Trevor
------------------------------------------------------------------------
------------------------------------------------
------------------------------------------------
Trevor Foley
Trevor Foley
Bankers Trust Australia Limited
Phone: 61-2-9259 3944    Fax: 61-2-9259 2659


        -----Original Message-----
        From:   Rejean Larivee [SMTP:rlarivee AT CA.IBM DOT COM]
        Sent:   Thursday, May 21, 1998 5:05 AM
        To:     ADSM-L AT VM.MARIST DOT EDU
        Subject:        Re: Chewed 3590 cartridge

        Hello,
        it is possible to find out which files are inactive on a
particular
        volume in adsm V3 using the select command. This particular
        select command will take quite a bit of time to complete so I do
        recommend you run this unless you can really afford it.
        Here it goes :

        select * from backups where DEACTIVATE_DATE<>'' and
         NODE_NAME || FILESPACE_NAME || HL_NAME || ' ' || LL_NAME in
         (select NODE_NAME || FILESPACE_NAME || FILE_NAME from
        contents where VOLUME_NAME='Chewed_3590_cartridge')

        Have fun !


-----------------------------------------------------------------
        Rejean Larivee
        Rejean Larivee
        ADSM Level 2 Support



        ---------------------- Forwarded by Rejean Larivee/Quebec/IBM on
05/20/98 03:47
        PM ---------------------------


        ADSM-L AT VM.MARIST DOT EDU on 05/19/98 03:32:27 PM
        Please respond to ADSM-L AT VM.MARIST DOT EDU
        To: ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject: Re: Chewed 3590 cartridge


        ---------------------------- Forwarded with Changes
---------------------------
        From: owner-adsm-l AT VM.MARIST DOT EDU at SMTP
        From: owner-adsm-l AT VM.MARIST DOT EDU at SMTP
        Date: 5/19/98 11:27AM
        To: Jerry Lawson at ASUPO
        *To: ADSM-L AT VM.MARIST DOT EDU at SMTP
        Subject: Re: Chewed 3590 cartridge

------------------------------------------------------------------------
-------
-------
        Not exactly true..... A Q content will tell you if the file is
        Not exactly true..... A Q content will tell you if the file is
still "in
        retention" - in other words - still managed by ADSM, but it does
not
        discriminate between active and inactive files.

        Jerry Lawson
        jlawson AT thehartford DOT com


        ______________________________ Forward Header
__________________________________
        Subject: Re: Chewed 3590 cartridge
        Author:  owner-adsm-l AT VM.MARIST DOT EDU at SMTP
        Date:    5/19/98 11:27 AM


             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



<Prev in Thread] Current Thread [Next in Thread>