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-Universitaet
Reinhard Mersch                     Westfaelische Wilhelms-Universitaet
Universitaetsrechenzentrum, Roentgenstrasse 13, 48149 Muenster, Germany
E-Mail: mersch AT uni-muenster DOT de                  Phone: +49(251)83-31583