You don't say what platform your server is on, but why not run the commands
via "cron" (for UNIX) or "at" for NT. We have both kinds of servers and
have both types of jobs set up. The scripts set the environment and the
location of the output file, then calls the sql macro, such as:
set path=c:\"program files"\Tivoli\TSM\baclient;%PATH%
set DSM_CONFIG=c:\program files\tivoli\tsm\baclient\dsm.opt
set DSM_DIR=c:\program files\tivoli\tsm\baclient
dsmadmc -id=<admin_id> -pa=<admin_id_password> -outfile >>
c:\tsm_reports\missed.file.txt macro c:\tsm_macros\missed.files.bat
The contents of the macro associated with the above is:
set sqldisplaymode wide
select date_time,TRIM(nodename),TRIM(message) from actlog where (msgno=4987
or msgno=4007) and ((current_timestamp-DATE_TIME)minutes<INTERVAL '1440'
minutes)
We have a job that runs daily on all our TSM servers that creates the
following reports and mails them to us:
* Missed files
* Completion status of previous 24 hour's backups
* Read-only & unavailable volumes
* Status of copypool job
* Status of DB backup job
* File systems with last backup greater than 24 hours
* Client nodes whose last access is greater than 24 hours
After receiving the info in the mail, you can save it, edit it or use it
with your favorite tools.
Anne Short
Lockheed Martin Enterprise Information Systems
Gaithersburg, Maryland
301-240-6184
CODA/I Storage Management
-----Original Message-----
From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 5:39 PM
To: [EMAIL PROTECTED]
Subject: Commands
I've been dabbling in trying to get the output of a command, through the
scheduler, to run and send the output to a file, either on the TSM server or
another computer. That file will be ftp'd to another computer and deciphered
there. I've been able to run the command from a TSM admin command prompt on
my computer but not through a command I made and put in a server command
script I can run through the scheduler. I'm not a programmer for sure so I
need some help. This can either be a select statement or query command as
long as I get a text output file. Here is what works from a dsmc command
prompt:
adsm> query drmedia * wherestate=mo > \\servername\temp\drmmo.txt
I tried to run the command from the command line on the web browser and a
server command script but get this output:
ANR2020E QUERY DRMEDIA: Invalid parameter - >.
I tried to run the command to redirect to the adsm server but it looks like
I don't have the syntax right because I haven't been able to do that either.
Unable to upen file blah blah blah for redirection.
If someone can help with this I'd truly appreciate it. Sorry I can't offer
prizes like Kelly can.
Geoff Gill
NT Systems Support Engineer
SAIC
Computer Systems Group
E-Mail: [EMAIL PROTECTED]
Phone: (858) 826-4062
Pager: (888) 997-9614
