ADSM-L

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

2001-11-26 14:47:31
Subject: Re: transmitting the result of an sql query to a script ? + loop struture ?
From: Martin Trcka <mtrcka AT SMPAS DOT CZ>
Date: Mon, 26 Nov 2001 14:38:05 +0100
Hi,
if you have RECLAIM parameter set on 100 in your copy sequential stg pool,
reclamation on volumes in that pool shouldn't occur at all.. Or am I missing
something ?

Best regards,
Martin Trcka

> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On
> Behalf Of PAC Brion Arnaud
> Sent: Thursday, November 22, 2001 11:01 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: transmitting the result of an sql query to a script ? +
> loop struture ?
>
>
> 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     |
> | Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland |
> | Phone: +41 61 226 19 78    /    Fax: +41 61 226 17 01 |
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=