Informix backup batch file for scheduling on NT 4.0

[malamba]

I run informix dynamic server 7.31 on an NT 4.0 server. When scheduling the Back up I use the batch file below:

===========================================================
echo Setting Informix environment
set INFORMIXDIR=D:\INFORMIX
set INFORMIXSERVER=ol_mtlvbserver
set ONCONFIG=ONCONFIG.ol_mtlvbserver
set PATH=D:\INFORMIX\bin;%PATH%;
set INFORMIXSQLHOSTS=\\mtlVBSERVER
set DBTEMP=d:\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

echo. | onunload -t \\.\TAPE0 -b 16 -s 25576000 verabill

if not errorlevel 1 goto end
echo Error during onunload backup ....

:end
echo. | date
echo. | time
echo "End of Backup ...."
============================================================


The above batch file was working properly with scheduling when my data only filled one 24 gig tape. Now I have to use 2 tapes since my data has grown. How can I improve this batch file so that at the end of filling the 1st tape it should wait for a user to hit enter upon insertng the second tape? In other words it should pause until some one hits enter signifying insertion of a second tape.

 

[appi]

Hi,

Why'd you use onunload ??? check to use ontape and I guess that will cause a wait on tape fillment. Use TAPEDEV Parameters to specify tape and use commands ontape -s or onbar -b -w <Database>.
regards
Uwe