Hello,
you are right, the select command I posted will only work
if you keep only 1 version of a file. If you keep mutliple
versions, it will not work, since the contents table table
does not reveal any connection to the object, as you
pointed out. I apologize for the incorrect information.
Good day !
Rejean Larivee
ADSM Level 2 Support
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------
Rejean,
Rejean,
interesting command, but ... are you sure?
This command seems to list all inactive backup copies (where ever they are)
of a file having one backup copy on the chewed cartridge. So, if "file_a"
has one active and four inactive backup copies and one of these copies is
on the chewed volumes, the four inactive copies will be listed, right?
And I still do not know, whether the affected copy is the active one or
one of the inactive ones, right?
Again, an unique connection between the CONTENTS table and the BACKUPS
table is missing. Without this connection, an entry in the CONTENTS table
does not tell me, which of the possibly many backup or archive copies of
a file it refers to. It seems to me, that the OBJECT_ID field should be
included in the CONTENTS table.
Rejean Larivee writes:
> 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
> ADSM Level 2 Support
--
Reinhard Mersch Westfaelische Wilhelms-UniversitaetReinhard
Mersch Westfaelische Wilhelms-Universitaet
Universitaetsrechenzentrum, Roentgenstrasse 13, 48149 Muenster, Germany
E-Mail: mersch AT uni-muenster DOT de Phone: +49(251)83-31583
|
