ADSM-L

Re: scheduler fails on tdp command scripts (still drives me nuts ) - My Way!

2002-11-21 10:39:35
Subject: Re: scheduler fails on tdp command scripts (still drives me nuts ) - My Way!
From: Tony Morgan <TONY.MORGAN AT FORTISBANK DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 21 Nov 2002 16:28:32 +0100
Hi there! No Nuts... Just the fruits of my labour!

This is how I do it on NT... it's a daily restore, but the principle is the
same.
Note the "exit 0" to set "errorlevel" to 0 and the "Progra~1" (no spaces).
The first file calls the second, output is redirected to a logfile with
timestamps.
Waitfor is an NT resource kit command.
"prompt $g" just makes the logfile less clutered.
2 copies of the log are retained.
Simple but effective!

Rgds
Tony Morgan
Fortis Bank SA/NV
UK Branch HQ
----------------------------------------------------------------------------
-------------
Objects Field
~~~~~~~~~~~~~
c:\progra~1\tivoli\tsm\baclient\RestoreDB1.cmd

RestoreDB1.cmd
~~~~~~~~~~~~~~
@echo on
c:
cd \progra~1\tivoli\tsm\baclient
del RestoreDB.old
ren RestoreDB.log RestoreDB.old
waitfor -t 2 fileclose
RestoreDB2.cmd >>Restoredb.log
waitfor -t 2 fileclose
exit 0

RestoreDB2.cmd
~~~~~~~~~~~~~~
prompt $g
@echo on
c:
cd \progra~1\tivoli\tsm\baclient
@echo Timestamp Log
@echo ----------------------------------------------------------------
Date /T
Time /T
@Echo Start Procedure
@echo ----------------------------------------------------------------
dsmc restore \\server1\c$\appx5\Server\admin\*.* \\server2\d$\appx5\Server\
-virtualnodename=server1 -subdir=yes -replace=all -tapeprompt=no -pas=XXX
dsmc restore \\server1\c$\appx5\Server\object\*.* \\server2\d$\appx5\Server\
-virtualnodename=server1 -subdir=yes -replace=all -tapeprompt=no -pas=XXX
dsmc restore \\server1\c$\appx5\Server\request\*.*
\\server2\d$\appx5\Server\  -virtualnodename=server1 -subdir=yes
-replace=all -tapeprompt=no -pas=XXX
@echo Timestamp Log
@echo ----------------------------------------------------------------
Date /T
Time /T
exit 0

-----Original Message-----
From: Koen Willems [mailto:koen_willems AT HOTMAIL DOT COM]
Sent: 21 November 2002 15:08
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: scheduler fails on tdp command scripts (still drives me
nuts )


I wish it was that easy for me,

on the object line I stated:

'"c:\program files\tivoli\tsm\agentoba\orcschedppim.cmd"'
I run the latest level.....

Nuts,

Koen.


>From: Mark Bertrand <Mark.Bertrand AT USUNWIRED DOT COM>
>Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>To: ADSM-L AT VM.MARIST DOT EDU
>Subject: Re: scheduler fails on tdp command scripts (still drives me nuts )
>Date: Thu, 21 Nov 2002 08:28:04 -0600
>
>Koen,
>
>OK, I'm going to step up and speak out. I had two similar problems not too
>long ago, and I'm really embarrassed about the mistakes that were made.
>
>The first was that when setting up the schedule I mistakenly put the path
>and script line in the Options box instead of Objects, yes I'm a GUI user.
>Not too ashamed about that one because it was a pretty easy mistake to
>find.
>
>The second one took about a week, the script would run error free from the
>client but failed in schedule and exited with
>
>ANS1512E Scheduled event '2330_YOUR_SCHED_SQL' failed.  Return code = 1.
>
>I knew the problem just had to be permissions or a client issue. I checked
>and changed permissions at the client, and within SQL. I upgraded to the
>latest TDP for SQL, still RC=1. I searched the archives but ANS1512E and
>RC=1 are WAY TOO generic (hint, hint IBM'ers) so I decided not to post or
>call it in since there was really no emergency since it would run OK
>manually. Just as you stated "drives me nuts".
>
>So I decided to break it down and go one step at a time, that's when I
>spotted on the Objects line, my node name instead of the server name for
>the
>path. ***I put my head down in shame***
>
>\\servername_sql\c$\progra~1\tivoli\tsm\tdpsql\sqlfull.cmd
>
>All is well now. Not to proud about that one, but hope it may help others.
>
>Mark B.
>
>
>
>-----Original Message-----
>From: Koen Willems [mailto:koen_willems AT HOTMAIL DOT COM]
>Sent: Thursday, November 21, 2002 7:52 AM
>To: ADSM-L AT VM.MARIST DOT EDU
>Subject: Re: scheduler fails on tdp command scripts (still drives me
>nuts )
>
>
>Manuel,
>
>You are a mind reader huh ;-)
>
>Using the NT scheduler is my fall back plan....
>
>But it isnt as nice as using the TSM scheduler..
>
>I am getting a little frustrated, normally the TSM scheduler works fine...
>
>Still clueless,
>
>Koen
>
>
>
>
>
>
> >From: Manuel Schweiger <manuel.schweiger AT CHELLO DOT AT>
> >Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> >To: ADSM-L AT VM.MARIST DOT EDU
> >Subject: Re: scheduler fails on tdp command scripts (still  drives me
>nuts
> >)
> >Date: Thu, 21 Nov 2002 14:44:06 +0100
> >
> >Koen,
> >
> >Until I changed it to run under admin rights (as mentioned before) I just
> >did a workaround in running the script with the windows scheduler. Not a
> >perfect solution but until someone can solve your problem on this you
>could
> >at least work with that.
> >
> >Regards, Manuel
> >
> >----- Original Message -----
> >From: "Koen Willems" <koen_willems AT HOTMAIL DOT COM>
> >To: <ADSM-L AT VM.MARIST DOT EDU>
> >Sent: Thursday, November 21, 2002 2:35 PM
> >Subject: Re: scheduler fails on tdp command scripts (still drives me nuts
>)
> >
> >
> > > Dear Del,
> > >
> > > the command scipt runs.. via DOS.
> > >
> > > The scheduler does not run the script.
> > >
> > > I see some brief communcation with the tsm server:
> > >
> > > My ac logs says:
> > >
> > > 11/21/2002 14:03:38   ANR0406I Session 1214 started for node
> >SERVER03_ORACLE
> > >                        (WinNT) (Tcp/Ip 172.16.1.249(1146)).
> > > 11/21/2002 14:03:38   ANR0403I Session 1214 ended for node
> >SERVER03_ORACLE
> > >                        (WinNT).
> > >
> > > The my schedlog say:
> > >
> > > 11/21/2002 14:25:58
> > > Executing Operating System command or script:
> > >    "c:\program files\tivoli\tsm\agentoba\orcschedppim.cmd"
> > > 11/21/2002 14:25:58 Finished command.  Return code is: 3
> > > 11/21/2002 14:25:58 ANS1909E The scheduled command failed.
> > > 11/21/2002 14:25:58 ANS1512E Scheduled event 'ORACLE_0130' failed.
> >Return
> > > code = 3.
> > > 11/21/2002 14:25:58 Sending results for scheduled event 'ORACLE_0130'.
> > > 11/21/2002 14:25:58 Results sent to server for scheduled event
> > > 'ORACLE_0130'.
> > >
> > > 11/21/2002 14:25:58 Querying server for next scheduled event.
> > > 11/21/2002 14:25:58 Node Name: SERVER010_ORACLE
> > > 11/21/2002 14:25:58 Session established with server BUS_SERVER1:
>Windows
> > > 11/21/2002 14:25:58   Server Version 5, Release 1, Level 5.0
> > > 11/21/2002 14:25:58   Server date/time: 11/21/2002 14:25:58  Last
> >access:
> > > 11/21/2002 14:25:58
> > >
> > > 11/21/2002 14:25:58 --- SCHEDULEREC QUERY BEGIN
> > > 11/21/2002 14:25:58 --- SCHEDULEREC QUERY END
> > > 11/21/2002 14:25:58 Next operation scheduled:
> > > 11/21/2002 14:25:58
> > > ------------------------------------------------------------
> > > 11/21/2002 14:25:58 Schedule Name:         ORACLE_0130
> > > 11/21/2002 14:25:58 Action:                Command
> > > 11/21/2002 14:25:58 Objects:               "c:\program
> > > files\tivoli\tsm\agentoba\orcschedppim.cmd"
> > > 11/21/2002 14:25:58 Options:
> > > 11/21/2002 14:25:58 Server Window Start:   14:25:00 on 11/22/2002
> > > 11/21/2002 14:25:58
> > > ------------------------------------------------------------
> > > 11/21/2002 14:25:58 Schedule will be refreshed in 6 hours.
> > >
> > > my errolog says:
> > >
> > > 11/21/2002 14:25:58 ANS1909E The scheduled command failed.
> > > 11/21/2002 14:25:58 ANS1512E Scheduled event 'ORACLE_0130' failed.
> >Return
> > > code = 3.
> > >
> > > I did an upgrade sched like this:
> > >
> > > update schedule oracle_domain oracle_0130 objects='"c:\program
> > > files\tivoli\tsm\agentoba\orcschedppim.cmd"'
> > >
> > > Best Regards,
> > >
> > > Koen Willems
> > >
> > >
> > >
> > >
> > >
> > > >From: Del Hoobler <hoobler AT US.IBM DOT COM>
> > > >Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> > > >To: ADSM-L AT VM.MARIST DOT EDU
> > > >Subject: Re: scheduler fails on tdp command scripts ( drives me nuts
>)
> > > >Date: Thu, 21 Nov 2002 08:10:05 -0500
> > > >
> > > >Koen,
> > > >
> > > >The first thing you should check is to make sure the
> > > >command script is even being run.
> > > >A good way to test this is to put a command in
> > > >script that generates some type of output on
> > > >the local machine that you can check.  That way
> > > >you can see if the script is even being executed.
> > > >For example:    DIR C:\TEMP > C:\TEMP\TEST.OUT.
> > > >If, after the schedule runs, the "TEST.OUT" file
> > > >is not generated, then the script is not even
> > > >being run and the problem is probably with the
> > > >definition of the schedule.
> > > >If that is the case...
> > > >
> > > >Are you specifying the full path name to the script
> > > >in the objects field of the defined schedule?
> > > >
> > > >Are there spaces in the path name? If there are,
> > > >you may have to use double quotes and single quotes
> > > >around the parameter when defining the "objects=xxx" option.
> > > >For example:
> > > >
> > > >    OBJECTS='"C:\Program Files\Tivoli\TSM\domino\dominc.cmd"'
> > > >
> > > >Notice the two sets of quotes, a set of single quotes
> > > >and a set of double quotes.
> > > >
> > > >Thanks,
> > > >
> > > >Del
> > > >
> > > >----------------------------------------------------
> > > >
> > > >Del Hoobler
> > > >IBM Corporation
> > > >hoobler AT us.ibm DOT com
> > > >
> > > >- Never cut what can be untied.
> > > >- Commit yourself to constant improvement.
> > > >
> > > >==============================================================
> > > > > > When isntalling a scheduler for my TDP with dsmcutil and
>defining
> >a
> > > > >schedule
> > > > > > on the server with action command and object the command script
> > > > > > all looks fine.
> > > > > >
> > > > > > The dsmched.log shows a new time slot and when I check on the
> >server
> >I
> > > > >get
> > > > >a
> > > > > > succes when entering q ev * *.
> > > > > >
> > > > > > The thing is that my backup has failed with. error 1 or 4.
> > > > > >
> > > > > > I already tried different user accounts. But this does not
>help...
> > > > > >
> > > > > > Anybody ????
> > >
> > >
> > > _________________________________________________________________
> > > The new MSN 8: smart spam protection and 2 months FREE*
> > > http://join.msn.com/?page=features/junkmail
>
>
>_________________________________________________________________
>Tired of spam? Get advanced junk mail protection with MSN 8.
>http://join.msn.com/?page=features/junkmail


_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail

============================================================

This e-mail and any files transmitted with it, are confidential and
intended solely for the use of the addressee. The content of this
e-mail may have been changed without the consent of the originator.
The information supplied must be viewed in this context. If you have
received this e-mail in error please notify our Helpdesk by
telephone on +44 (0) 20-7444-8444. Any use, dissemination,
forwarding, printing, or copying of this e-mail or its attachments is
strictly prohibited.

<Prev in Thread] Current Thread [Next in Thread>
  • Re: scheduler fails on tdp command scripts (still drives me nuts ) - My Way!, Tony Morgan <=