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
|