.
Is this perhaps a problem that could be solved another way, via
throughput thresholds?

Roger Deschner      University of Illinois at Chicago     rogerd AT uic DOT edu


On Fri, 5 Dec 2008, Allen S. Rout wrote:

>
>I'm encountering an infrastructure problem on campus which ends up
>with a bunch of sessions periodically entering RecvW status, and
>staying there indefinitely.
>
>We're working on fixing the network layer problem, but until that
>happens, I'm having to do something like:
>
>
>dsmadmc -se=ext -id=query -password=query -dataonly=yes -tab "select 'cancel 
>sess '||cast(session_id as char(9)) from sessions where state='RecvW' and 
>wait_seconds >= 500"
>
>which generates a bunch of output that I can then copy and paste into
>an appropriate server window.
>
>I thought to myself, "Gee, I can write a script that
>
>Runs a query to see if there are any candidate sessions
>
>if not, then exit.
>
>If so, then run another query to generate the commands I want to
>execute.  Dump this to a macro. (or script)
>
>Run the macro/load and run the script.
>
>
>Straightforward.  Unfortunately, it doesn't appear that I can write to
>a file from one of my scripts, and TSM Quickfacts confirms this.  (Oh,
>and the official docs do, too. ;)
>
>
>So, I'm wondering: How do you-all do such a thing?  I'm reluctant to
>regenrate a script every hour from CRON, for example.  sounds iffy.
>
>
>
>- Allen S. Rout
>