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 <[EMAIL PROTECTED]>@VM.MARIST.EDU> on > 02/20/2001 06:54:04 AM > > Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> > > Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> > > To: [EMAIL PROTECTED] > 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 > > [EMAIL PROTECTED] > > > > "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: [EMAIL PROTECTED] > > <lipp@storsol. cc: > > com> Subject: Re: deleting copypool > tapes. > > Sent by: > > "ADSM: Dist > > Stor Manager" > > <[EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] or [EMAIL PROTECTED] > > www.storsol.com > > www.storserver.com > > > > -----Original Message----- > > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of > > Shekhar Dhotre > > Sent: Wednesday, February 14, 2001 12:10 PM > > To: [EMAIL PROTECTED] > > 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 > $RFC822.eml Type: application/x-unknown-content-type-eml_auto_file > Encoding: base64 -- Mit freundlichen Grüßen Bernhard Unold
begin:vcard n:Unold;Bernhard tel;work:+49 7071/29-80130 x-mozilla-html:FALSE adr:;;;;;; version:2.1 email;internet:[EMAIL PROTECTED] fn:Bernhard Unold end:vcard
