Also, the string in the where clause needs to be quoted.

dsmadmc select * from volumes WHERE STGPOOL_name='COPYPOOL'

On Tue, 20 Feb 2001, Bernhard Unold wrote:

> 1) The poolnames in the output of dsmadmc are in CAPITAL letters. So you
> can try
>   dsmcadmc q vol | grep COPYPOOL
> or
>   dsmcadmc q vol | grep -i copypool
> 2) Try the following:
>   dsmadmc select * from volumes WHERE STGPOOL_name=COPYPOOL
> 3) You can get more info with
>   dsmadmc help select
>   dsmadmc select * from tables
> 
> 
> Shekhar Dhotre schrieb:
> > 
> > Hi ,
> > trying to get output of the copypool tapes ,
> > 
> > medrs2:dsmadmc -id=shekhar  -pa=himalaya q vol | grep copypool > /tmp/tape
> > medrs2:cd /tmp
> > medrs2:ls -la tape
> > -rw-r--r--   1 root     system         0 Feb 20 09:13 tape       (This file 
> > shows `0`  bytes  in size.  )
> > medrs2:
> > 
> > tsm: TSM>select * from volumes whertestgpool=copypool
> > ANR2907E Unexpected SQL operator token - '='.
> > 
> >                                             |
> >          ...................................V........
> >          select * from volumes whertestgpool=copypool
> > 
> > ANS8001I Return code 3.
> > 
> > tsm: TSM>help ANR2907E
> > -------------------------------------------------------------------------------
> > 
> > 
> > ANR2907E Unexpected SQL operator token - 'token'.
> > 
> > Explanation: A syntax error occurred because an SQL operator token was found
> > that can not legally be used at the specified position within the SQL
> > statement. Examples of SQL operator tokens are +, *, <, and =.
> > 
> > System Action: The SQL query is terminated.
> > 
> > User Response: None.
> > 
> > Bernhard Unold <Bernhard.Unold AT MED.UNI-TUEBINGEN DOT DE>@VM.MARIST.EDU> 
> > on
> > 02/20/2001 06:54:04 AM
> > 
> > Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> > 
> > Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> > 
> > To:   ADSM-L AT VM.MARIST DOT EDU
> > cc:
> > 
> > Subject:  Re: deleting copypool tapes.
> > 
> > Tsm doesn't allow  wildchars in the volume name of the delete command.
> > So you can make a script with awk or something else. First generate a
> > list of the volumes:
> >   dsmcadmc q vol | grep copypool
> > or
> >   dsmadmc select * from volumes WHERESTGPOOL=COPYPOOL
> > WHEREDEVCLASS=STK9710
> > and take the list as input for awk to generate the delete commands.
> > 
> > Nicholas Cassimatis schrieb:
> > >
> > > Select the volumes with the GUI, and pick Delete!
> > >
> > > Nick (Don't mess with my GUI)  Cassimatis
> > > nickpc AT us.ibm DOT com
> > >
> > > "I'm one cookie away from happy." - Snoopy (Charles Schulz)
> > > ----- Forwarded by Nicholas Cassimatis/Raleigh/IBM on 02/19/01 01:19 PM
> > > -----
> > >
> > >                     "Kelly J.
> > >                     Lipp"                To:     ADSM-L AT VM.MARIST DOT 
> > > EDU
> > >                     <lipp@storsol.       cc:
> > >                     com>                 Subject:     Re: deleting 
> > > copypool
> > tapes.
> > >                     Sent by:
> > >                     "ADSM: Dist
> > >                     Stor Manager"
> > >                     <ADSM-L AT VM DOT MAR
> > >                     IST.EDU>
> > >
> > >                     02/14/01 02:46
> > >                     PM
> > >                     Please respond
> > >                     to lipp
> > >
> > > One at a time!
> > >
> > > Kelly J. Lipp
> > > Storage Solutions Specialists, Inc.
> > > PO Box 51313
> > > Colorado Springs CO 80949-1313
> > > (719) 531-5926
> > > Fax: (240) 539-7175
> > > Email: lipp AT storsol DOT com or lipp AT storserver DOT com
> > > www.storsol.com
> > > www.storserver.com
> > >
> > > -----Original Message-----
> > > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On 
> > > Behalf Of
> > > Shekhar Dhotre
> > > Sent: Wednesday, February 14, 2001 12:10 PM
> > > To: ADSM-L AT VM.MARIST DOT EDU
> > > Subject: deleting copypool tapes.
> > >
> > > Hi all ,
> > >    what is the command that will delete all (90)  copypooltapes  in one
> > > shot
> > > ..
> > > I am trying
> > >
> > >  DELETE VOLUME   *   WHERESTGPOOL=COPYPOOL WHEREDEVCLASS=STK9710
> > > discarddata=yes  with no luck
> > > 02/14/01   13:34:08  ANR2401E DELETE VOLUME: Volume * is not defined in a
> > >
> > > thanks
> > > shekhar
> > 
> > --
> > Mit freundlichen Grüßen
> > 
> > Bernhard Unold
> > (See attached file: Bernhard.Unold.vcf)
> > 
> >   ------------------------------------------------------------------------
> >                   Name: $RFC822.eml
> >                   Name: $RFC822.eml
> >    $RFC822.eml    Type: application/x-unknown-content-type-eml_auto_file
> >               Encoding: base64
> 
> -- 
> Mit freundlichen Grüßen
> 
> 
> Bernhard Unold