Let SQL do it for you!!
Pipe the output of these commands to a file...(make sure the storagepool
name is upper case. It matters!)...
SET SQLDISPLAYMODE WIDE
SELECT 'DEL VOL ' || TRIM(VOLUME_NAME) || ' DISCARD=YES WAIT=YES' FROM
VOLUMES WHERE STGPOOL_NAME='<uppercase storage pool name>'
You can then edit the output and feed it into dsmadmc as a macro or just
cut'n'paste. You should do the WAIT=YES to avoid database contention and
possible lock-out conditions.
Bill Boyer
DSS, Inc.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Loon, E.J. van - SPLXM
Sent: Monday, December 01, 2003 6:43 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: deleting 1200 volumes (== one stgpool)
Hi Remco!
This is what I would do:
dsmadmc -commadelimited
q vol stgpool=obsoltestgpool > c:\temp\vollist.txt
Open this file in Excel, insert a column before, where you type del volume
and drag this line all the way down. Do the same in the column C and type
there discarddata yes wait=yes. Also drag this column all the way down.
Now save the file as text file and you have a nice macro file which you can
use as input for dsmadmc.
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines
-----Original Message-----
From: Remco Post [mailto:r.post AT SARA DOT NL]
Sent: Sunday, November 30, 2003 00:38
To: ADSM-L AT VM.MARIST DOT EDU
Subject: deleting 1200 volumes (== one stgpool)
Hi all,
we recently migrated our copy storage pool from one medium to another.
Now, the migration is finished and I have a copy storagepool with 1200
volumes in it, that all can be deleted.
Now since I'm not the kind of guy that likes typing del vol <vsn>
discarddata=y 1200 times, I was wondering if anybody happens to have a
nice script available to clear out a storagepool?
--
Met vriendelijke groeten,
Remco Post
SARA - Reken- en Netwerkdiensten http://www.sara.nl
High Performance Computing Tel. +31 20 592 8008 Fax. +31 20 668 3167
"I really didn't foresee the Internet. But then, neither did the
computer
industry. Not that that tells us very much of course - the computer
industry
didn't even foresee that the century was going to end." -- Douglas Adams
**********************************************************************
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain confidential
and privileged material intended for the addressee only. If you are not the
addressee, you are notified that no part of the e-mail or any attachment may
be disclosed, copied or distributed, and that any other action related to
this e-mail or attachment is strictly prohibited, and may be unlawful. If
you have received this e-mail by error, please notify the sender immediately
by return e-mail, and delete this message. Koninklijke Luchtvaart
Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be
liable for the incorrect or incomplete transmission of this e-mail or any
attachments, nor responsible for any delay in receipt.
**********************************************************************
|