Greetings.

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