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
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 ---------------------------