http://www.uni-karlsruhe.de/~rz57/ADSM/3rd/handouts/raibeck.ps is a good
reference on SQL commands for ADSM.

select * from volumeusage where node_name='XXX' will tell you ALL (primary
and copy tape pools) the tapes your data is on.

James Louie
Nabisco

> -----Original Message-----
> From: Bill Colwell [mailto:bcolwell AT DRAPER DOT COM]
> Sent: Tuesday, March 30, 1999 3:58 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Anyone have a list of SELECT commands handy.
>
>
> I don't have a list of handy commands.  I suggest becoming familiar
> with whats in the adsm sql database.  Sql databases are self defining,
> if you know the starting point you can explore the whole thing.  For
> adsm, the starting point is --
>
> select * from syscat.tables
>
> The next step would be --
>
> select * from syscat.columns
>
> Pay attention to the remarks column.
>
> --
> --------------------------
> Bill Colwell
> C. S. Draper Lab
> Cambridge, Ma.
> bcolwell AT draper DOT com
> --------------------------
>
> In <30MAR99.16898925.0070.MUSIC AT MUSICA.MCGILL DOT CA>, on 03/30/99
>    at 03:38 PM, "Mark Brown (CC Operations Supervisor)"
> <CCMB AT MUSICA.MCGILL DOT CA> said:
>
> >Hello,
>
> >I am a newbie when it comes to SELCT commands for querying
> my MVS os390
> >ADSM v3 server. Is there a place where I can download "sample" select
> >commands? I have used up the samples in the ADSM manual.
>
> >In particular I would like a command that can tell me which
> tapes a nodes
> >files are on WITHOUT mounting a tape.
>
>
>
> >Thank You,
> >  Mark Brown, Operations Supervisor
> >  McGill University, Computing Centre
> >  Phone (514) 398-2321
> >  E-Mail --> ccmb AT musica.mcgill DOT ca
> >  Home Page --> http://mbrown.cc.mcgill.ca
>