Re: wildcard del vol?
2006-12-05 18:18:15
Use the SQL contatenation operator:
Select 'del vol ' || volume_name from volumes where
stgpool_name='WHATEVERINCAPS'...
Do it right from the dsmadmc command prompt and cut 'n paste right back to
execute them. You may have to issue SET SQLDISPLAYMODE
WIDE so it all fits on a single line.
Actually now that I think about it, if you try to cut n' paste it back in to
the dsmadmc command line, you get prompted Yes or No
after the first DEL VOL command is issued. Probably better to pipe the output
to a file and then use the macro command like Allen
used.
Bill Boyer
>Select * from USERS where CLUE>0
0 rows returned
- ??
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Allen S. Rout
Sent: Tuesday, December 05, 2006 5:32 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: wildcard del vol?
>> On Tue, 5 Dec 2006 16:21:47 -0500, Lawrence Clark <Larry_Clark AT
>> THRUWAY.STATE.NY DOT US> said:
> Since I'm redoing the volumes on SAN and need to delete the ones auto
> generated by TSM, is there a way of wholesale deleteing the existing
> volumes without doing an explicit del vol on each?
dsmadmc -dataonly -tab " select 'del vol ',volume_name,' wait=yes' where
your_criterion_here " > something.macro
then
TSM:your_server > macro something.macro
- Allen S. Rout
|
|
|