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. itself ?!!! :-(( Regards. Arnaud
-----Original Message----- From: Baines, Paul [mailto:[EMAIL PROTECTED]] Sent: Donnerstag, 22. November 2001 12:01 To: [EMAIL PROTECTED] Subject: AW: transmitting the result of an sql query to a script ? + loop struture ? 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 "cancel proc $proc" done Mit freundlichen Gr��en - With best regards Serdeczne pozdrowienia - Slan agus beannacht Paul Baines TSM/ADSM Consultant -----Urspr�ngliche Nachricht----- Von: PAC Brion Arnaud [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 22. November 2001 11:01 An: [EMAIL PROTECTED] Betreff: 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 | =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
