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)
=?iso-8859-1?Q?Bernhard.Unold.vcf?=
=?iso-8859-1?Q?$RFC822.eml?=
