Lisa,

I have successfully captured the output of the following pre/post commands
when shutting down and restarting an Oracle database prior to running a
scheduled backup.

I am running a Windows NT Version 4.0 backup Server and TSM version 4.1.1.0

In the clients DSM.OPT file the following commands have been entered:
preschedulecmd "c:\oracle\admin\bat\shutdownoracle.cmd"
postschedulecmd "c:\oracle\admin\bat\startuporacle.cmd"

the following are the command files that redirects the shutdown and startup
to a text file:

shutdownoracle.cmd
set ORACLE_SID=XYDEV
set ORACLE_HOME=c:\oracle\ora81
c:\oracle\ora81\bin\svrmgrl.exe @c:\oracle\admin\sql\shutdown.sql > c:
\oracle\admin\bat\pre_cmd_results.txt
net stop oracleserviceBVDEV /y

startuporacle.cmd
set ORACLE_SID=XYDEV
set ORACLE_HOME=c:\oracle\ora81
net start oracleserviceBVDEV /y
c:\oracle\ora81\bin\svrmgrl.exe @c:\oracle\admin\sql\startup.sql > c:
\oracle\admin\bat\post_cmd_results.txt

Hope this helps!!

Regards

Russell Walsh
Professional Server Specialist, IBM GSA, Australia
Phone:    +61 3 9627.0158     Desk
     +61 3 9627.0340     Fax
     0411.263.409   Mobile
Internet: russelw AT au1.ibm DOT com



Lisa Cabanas <CABANL AT MAIL.MODOT.STATE.MO DOT US>@VM.MARIST.EDU> on 06/03/2001
07:48:08

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
cc:
Subject:  capture output from prescheduled command



I am trying to figure out how to capture the output of an ncompact.exe -B
command (a Domino server command that reassigns new DBIIDs to the compacted
databases) that is run as a prescheduled command in a special dsm_sel.opt.
The
scheduler picks up the schedule, and the selective TDP backup occurs, (and
says
it is using the c:\progra~1\tivoli\tsm\domino\dsm_sel.opt)  but I can not
tell
whether the compact was successful.

I have tried putting the statement in the dsm_sel.opt file

preschedcommand d:\domino\ncompact.exe -B 10 >>
c:\progra~1\tivoli\tsm\domino\compact.log
with all sorts of variations of where the quotes are-- no out put.


I have also tried putting these commands into another command file that is
called by the prescheduled command, and no go on it, either.


Has anyone done this?

thanks!!
lisa