ADSM-L

transmitting the result of an sql query to a script ? + loop struture ?

2001-11-22 05:42:29
Subject: transmitting the result of an sql query to a script ? + loop struture ?
From: PAC Brion Arnaud <arnaud.brion AT PANALPINA DOT COM>
Date: Thu, 22 Nov 2001 11:01:23 +0100
Hi TSM'ers !

I already saw this in a thread, but can't find it again : I'm looking
for a convenient way to stop some reclamation processes in an automated
way (script).
As  those reclamation processes are made on an offsite stg pool, no way
stopping them by increasing the reclamation threshold to 100, so I
thought to something  like :
select process_num from processes where process='Space Reclamation' ,
and then transmit this "process_num" to a cancel proc command.
Is there a convenient way doing that, without calling an external AIX
script ?
More clever : if I have several of those reclamation processes, is there
a way building a loop in the script, to cancell them all, while running
the script once ?
TIA.
Arnaud

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
| Arnaud Brion, Panalpina Management Ltd., IT Group     |
| Arnaud Brion, Panalpina Management Ltd., IT Group     |
| Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland |
| Phone: +41 61 226 19 78    /    Fax: +41 61 226 17 01 |     
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
=======================================================================