Hi Lhing,

Could you post an example of the SELECT command, to clarify this solution
?!?

Also, we've started using separate disk storage pool for NT & AIX
directories... it keeps them from being scattered among several tapes, so
restore & MOVE DATA mount requests are (mostly) just the data files.

Thanx,

Don France


> -----Original Message-----
> From: Chintawongvanich, Thida T SHLTHAI-TSAPT/22
> [mailto:Thida.Chintawongvanich AT SHELL.CO DOT TH]
> Sent: Thursday, March 02, 2000 5:48 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: MOVE DATA associated volumes
> 
> 
> Hi Steven,
> 
>         If you set collocation=yes then 
>         first You must select volume name of node_name that 
> you want to
> reclaim tape ,if not you must select all volume name in that 
> storage pool.
> And now you can see that which one is in set of tape you can mixed it
> together
> Just select  file_name,segment   from contents where volume 
> name='.....' and
> segment <> '1/1' then you can see that which volume connect 
> with which one
> (the file that was sepertated will have segment not equal to 1/1.)
> ######you can't select with no condition of volume_name from contents
> because this is the index column.##############
> 
> Lhing
> > -----��ͤ����鹩�Ѻ-----
> > �ҡ:    Steven Bridge [SMTP:ccaasub AT UCL.AC DOT UK]
> > �������:     Thursday, March 02, 2000 06:39 PM
> > �֧:    ADSM-L AT VM.MARIST DOT EDU
> > ����ͧ:   MOVE DATA associated volumes
> > 
> > I am reclaiming space from tape volumes using the MOVE DATA command.
> > More often than not, after starting the command , you see that it
> > requires an associated tape volume as well as the one you are trying
> > to empty.
> > 
> > Is there any way I can determine, before giving the command,
> > what other tapes will be needed for successful completion of the
> > MOVE DATA command ?  When many of the tapes in question are 
> outside of
> > the tape library, it will obviously be helpful to be able to load up
> > all the tapes that might be required at once.
> > 
> > 
> +-------------------------------------------------------------
> ---------+
> >  Steven Bridge     Systems Group, Information Systems, EISD
> >                           University College London
> >  email: s.bridge AT ucl.ac DOT uk                   tel: +44 (0)20 
> 7679 2794
>