Scheduling onunload
I am running IDS 9.3 on Windows NT (first mistake).
I want to back up my database using onunload, but since it asks you to mount
the tape and press RETURN, I am not sure how to schedule this to have it run
automatically. Is there a way to buypass pressing ENTER?
Yes.
I don't normaly runs onunload, I uses ontape for my backup, but I thing =
my method works.
You need to make 2 files .bat file + yes file, look into the attach =
files:
M.v.h.
Laila Holt Larsen
lhl@djoef.dk
Danmarks Jurist og =D8konomforbund
IT-afdelingen
DJ=D8F
33 - 959944
Denmark
-----Oprindelig meddelelse-----
Fra: CHAD SMITH [mailto:csmith@unitedtexas.com]=20
Sendt: 7. november 2003 23:00
Til: ids@iiug.org
Emne: Scheduling onunload [2144]=20
I am running IDS 9.3 on Windows NT (first mistake). I want to back up my =
database using onunload, but since it asks you to mount the tape and =
press RETURN, I am not sure how to schedule this to have it run =
automatically. Is there a way to buypass pressing ENTER?
DQp5
------_=_NextPart_001_01C3A78D.DECB48B6--
Cut and paste this into a bat file. You have to set your environment
variables when using this in a scheduled task in NT. Make sure you change
the settings to match your environment and change the -s size as well. Make
sure it is big enough to contain your entire database. Onunloads are
usually bigger than a Level 0 backup.
If you have multiple database to onunload at the same time let me know. I
have a script that does as well.
Lennie
------------------------------ Code Start
----------------------------------------
@echo off
rem
rem setup the environment
rem
set INFORMIXDIR=C:\\\\informix
set INFORMIXSERVER=your_server_name
set ONCONFIG=ONCONFIG.your_server_name
set PATH=C:\\\\informix\\\\bin;%PATH%;set DBTEMP=C:\\\\informix\\\\infxtmp
set CLIENT_LOCALE=EN_US.CP1252
set DB_LOCALE=EN_US.8859-1set SERVER_LOCALE=EN_US.CP1252
set DBLANG=EN_US.CP1252
mode con codepage select=1252 >nul
echo.>return.txt
echo.>your_db_name.onu
onunload -b 1024 -s 50000000 -t full_path\\\\your_db_name.onu your_db_name <
return.txt > nul
------------------------------ Code End
----------------------------------------
-----Original Message-----
From: CHAD SMITH [mailto:csmith@unitedtexas.com]
Sent: Friday, November 07, 2003 4:00 PM
To: ids@iiug.org
Subject: Scheduling onunload [2144]
I am running IDS 9.3 on Windows NT (first mistake). I want to back up my
database using onunload, but since it asks you to mount the tape and press
RETURN, I am not sure how to schedule this to have it run automatically. Is
there a way to buypass pressing ENTER?