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 <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 12.11.2002 22:51 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] 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