ADSM-L

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

2001-11-26 15:14:41
Subject: Re: transmitting the result of an sql query to a script ? + loop struture ?
From: Robin Sharpe <Robin_Sharpe AT BERLEX DOT COM>
Date: Mon, 26 Nov 2001 15:11:03 -0500
If I remember correctly, to stop a reclamation (primary or copy), you have
to first set the threshold to 100, then cancel whatever processes may be
running... even then, they will finish whatever file they are currently
moving.  I think that could all be done in a server script, but I prefer to
script at the OS level, usually in perl...
Robin Sharpe
Berlex Labs



                    Martin Trcka
                    <mtrcka@SMPAS
                    .CZ>          To:    ADSM-L AT VM.MARIST DOT EDU
                                  cc:    (bcc: Robin Sharpe/WA/USR/SHG)
                    11/26/01      Subject:
                    08:38 AM             Re: transmitting the result of an sql 
query to a script ? + loop
                    Please               struture ?
                    respond to
                    "ADSM: Dist
                    Stor Manager"







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 |
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=