Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

auto backup scripts

Status
Not open for further replies.

Nagle

Programmer
Mar 3, 2005
1
US
We have a backup that will not run during its scheduled time, to complete the backup it must be done manually. It had worked in the past but for some unknow reason (to me at least) it now has to be done manually. Any help or ideas on where to look would be much appreciated.
 
more info is needed.
how exactly do you backup? (crontab job? which command?)
when does it fail? does it start at all? or will the backup itself not start or not complete?
do you start the same scripts when you start backup manually?
 
We are using WinAt to schedule, and the problem seems to be that it does not seem to be linked with the informix prompt portion of the interface.

Command: onbar -b -w -L 0

scheduled to run at 8 p.m.

In the WinAt it says the script was run at the proper time, but when I open the IECC and/or ISM administrator portion there is no evidence of the backup running and saving to the data tape (data inventory shows no information).
 
will the onbar-command execute when you enter it at the commandline manually? if so, are you sure, that the proper environment is set, when the task is started unattended?

try to give the complete path to onbar with the command or better place the command in a script and set the proper environment in the lines before.

e.g.

c:\programs\informix\bin\onbar <bla>
 
Onbar runs correctly manually, also if I run the script it runs with no problem.

Here is the script : sysdbbkup.cmd

call m:\informix\clncldbs.cmd

onbar -b -w -L 0
---------------------
clncldbs.cmd :
set INFORMIXDIR=M:\INFORMIX
set INFORMIXSERVER=clncldbs
set ONCONFIG=ONCONFIG.clncldbs
set PATH=M:\INFORMIX\bin;%PATH%;
set INFORMIXSQLHOSTS=\\&quot;ServerName&quot;
set DBTEMP=M:\INFORMIX\infxtmp
set CLIENT_LOCALE=EN_US.CP1252
set DB_LOCALE=EN_US.8859-1
set SERVER_LOCALE=EN_US.CP1252
set DBLANG=EN_US.CP1252
mode con codepage select=1252

I guess the real question is why is this not running at the specified time?
 
Check the onbar log (mine is in {letter}:\informix\bar{something}.log
usually onbar can only be run by user informix (must be the LOCAL user informix!)
If it turns out, that it is this, you may install &quot;su&quot; or &quot;runas&quot;.

Muelli
 
We are using legato backup for informix.
Some times hot backup is failed. some times it's sucessful.
I don't know why it's happened ?. Help me in this issue
 
We are using legato backup for informix.
Some times hot backup is failed. some times it's sucessful.
I don't know why it's happened ?. Help me in this issue
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top