> select file_name form contents where node_name='Sprint800"

'Sprint800' probably wont work, it has lowercase in it. (not positive
though)
Try SPRINT800.

But, I would narrow it down a bit more.
First find what tape it may be on:

select volume_name from volumeusage where node_name='SPRINT800' and
stgpool_name='YOURPOOLNAME' and filespace_id=idnumber

then for each tape volume name:

select file_name from contents where volume_name='volname' and
node_name='SPRINT800' and filespace_id=idnumber and file_name like
'directory filename'

The format of the file_name search is probably the toughest to get right if
you don't know what directory it is in.  ALso if it is Windows, make sure
it is upper case, if Unix get the case correct.

You could run "select file_name from contents where ..." without the
'file_name' part and > it to a file and look there later.  or use 'q
content volumename f=d > file' to a file nd look in the file

Matt Glanville




                      Christian Demnitz
                      <christian.demnitz@         To:      ADSM-L AT VM.MARIST 
DOT EDU
                      SINIUS.COM>                 cc:
                      Sent by: "ADSM:             Subject: Antwort: Re: 
Antwort: Re: Antwort: Re: Antwort: How would I check to
                      Dist Stor Manager"          see if filesare on 
tapealready?
                      <[email protected]
                      DU>


                      11/08/04 10:05 AM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






Hi,

I dont't know another way!

Christian Demnitz




Timothy Hughes <Timothy.Hughes AT OIT.STATE.NJ DOT US>
Gesendet von: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
08.11.2004 16:00
Bitte antworten an
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


An
ADSM-L AT VM.MARIST DOT EDU
Kopie

Thema
Re: Antwort: Re: Antwort: Re: Antwort: How would I check to see if
filesare on tapealready?






Christian
The command I am entering is

select file_name form contents where node_name='Sprint800"

Is this correct? It is taking very long is there another way to find
these files?

Thanks for your help!

Christian Demnitz wrote:

> Timothy
>
> yes, you can use this command on the tsm server command line!
>
> Christian Demnitz
>
> Timothy Hughes <Timothy.Hughes AT OIT.STATE.NJ DOT US>
> Gesendet von: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> 08.11.2004 15:15
> Bitte antworten an
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
> An
> ADSM-L AT VM.MARIST DOT EDU
> Kopie
>
> Thema
> Re: Antwort: Re: Antwort: How would I check to see if files are on
> tapealready?
>
> Christian,
>
> Can enter this command on the server command line?
>
> Christian Demnitz wrote:
>
> > ok, try this:
> >
> > select file_name from contents where node_name='xxx'
> >
> > Christian Demnitz
> >
> > Timothy Hughes <Timothy.Hughes AT OIT.STATE.NJ DOT US>
> > Gesendet von: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> > 08.11.2004 14:42
> > Bitte antworten an
> > "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> >
> > An
> > ADSM-L AT VM.MARIST DOT EDU
> > Kopie
> >
> > Thema
> > Re: Antwort: How would I check to see if files are on tape already?
> >
> > I don't know what tape the files are on but I know
> > the node? Sorry for the lack of Information.
> >
> > Thanks
> >
> > Christian Demnitz wrote:
> >
> > > q content <vol_name>
> > > or
> > > select * from contents (select xxx from contents where
> "vol_name"="xxx")
> > > and so on!
> > >
> > > but be carefully! takes very long time, shows every file on this
tape!
> > >
> > > Christian Demnitz
> > >
> > > Timothy Hughes <Timothy.Hughes AT OIT.STATE.NJ DOT US>
> > > Gesendet von: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> > > 08.11.2004 14:16
> > > Bitte antworten an
> > > "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> > >
> > > An
> > > ADSM-L AT VM.MARIST DOT EDU
> > > Kopie
> > >
> > > Thema
> > > How would I check to see if files are on tape already?
> > >
> > > How would I check to see if files are on tape already?
> > > Using TSM.
> > >
> > > Thanks in advance