Ron,

the short answer to your question is "TSM server has scripting abilities".
The long one might be like an essay or closer to a novel (depending on the
answering person).
I prefer to write scripts even for simple things like "select
current_date,current_time from db" (my favorite datetime script). Later
"run <script name>" does the job.
In your case you can define a script:
def scr vol_unav 'q v acc=unav' desc='List unavailable volumes'

and later operators can run it:
run vol_unav

If you want output to be feed back as commands things get more tricky. You
will have to write something like:
select 'upd v ' concat volume_name concat ' acc=readw' as -
"------------------------------------------------------------" -
from volumes where access='READWRITE' >vols.mac

And then stripe out the headers and use it as a macro.

Zlatko Krastev
IT Consultant






Ron Lochhead <RLochhead AT CSE-INSURANCE DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
12.11.2002 22:51
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        How to write script to automate TSM 5.11


I am attempting to find out how to write scripts for TSM 5.11 in an Win 2k
environment to automate the various commands during a backup.  Currently,
I
am using the command line to access the TSM server thru my workstation.
What I want to do is write a script for instance, "q vol *
access=unavailable" which an operator could type one command and get
results of which vols need to be updated.  Then that output file would be
the input for the "upd vol [volname] access=readwrite".

If anyone has written that or knows where I can go to find out that info,
I
would appreciate it.

Thanks,
Ron Lochhead