. Is this perhaps a problem that could be solved another way, via throughput thresholds?
Roger Deschner University of Illinois at Chicago [EMAIL PROTECTED] 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 >
