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

2001-11-27 Thread PAC Brion Arnaud
Hi Martin, and all folks that already answered my question ... First of all, thanks a lot for everyone that sent me an answer, most of the time not the one I expected, but never mind ;-) Martin, you're absolutely right, but in my case the problem was not to avoid reclamation occuring, but to

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

2001-11-27 Thread Robin Sharpe
Here's one that we use every day, and it works pretty well... from an AIX 4.3.3 machine. This kills any running reclaims: # Kill any reclaim processes that are running alias dsmadmc=dsmadmc -id=maestro -pa=admin list_reclaim_pids() { dsmadmc select process_num from processes where

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

2001-11-26 Thread Martin Trcka
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:[EMAIL PROTECTED]]On Behalf Of

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

2001-11-26 Thread Robin Sharpe
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

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

2001-11-26 Thread bbullock
As yet another example of the numerous ways to do the same task in unix. Here's a simple script I wrote a while back to do the same task: for i in $( dsmadmc -se=xxx -id=xxx -password=xxx select PROCESS_NUM from processes where PROCESS like 'Space Reclamation' |grep '[0-9]'

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

2001-11-22 Thread Baines, Paul
I can't think how you'd do it without a shell script. Try this (not tested!) for proc in `dsmadmc -se=xxx -id=xxx -password=xxx -tab select '#!#!', process_num from processes where process='Space Reclamation' | awk '/^#!#!/ {printf(%d\n, $2)}'` do dsmadmc -se=xxx -id=xxx -password=xxx -tab

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

2001-11-22 Thread PAC Brion Arnaud
Hi Paul, And thanks for your script, if I don't find any other mean transmitting this parameter to a TSM script I'll use it (or something similar). But why on hell did TSM engineers not think to such a facility, that would avoid having part of TSM tools inside the server and other parts in O.S.