bfreedlander
New Member
I am using progress 9.1d on a windows 2003 server.
I am trying to create a bat file to run each night to:
1. take down my database that has ai
2. backup my ai file (I only have 1 variable length file)
3. backup my database (about 2gb in size, takes about 3 minutes)
4. restart my database with ai
Below is my script. The rem'd lines represent the lines of code in the called bat files. The batch file works well until it gets to starting the database. It does start the database but it keeps the backup.log file locked until I take the database down. If I run the start database bat file individually from a cmd prompt then all is well (the backup.log file is not locked). Below the script is the data found in the backup.log.
Does anyone have any idea why this is happening?
rem Backup steps
echo shutdown the database at %DATE% %TIME% > c:\temp\backup.log
call R:\Syte6\ksb\batch\z-stopsyteline.bat >> c:\temp\backup.log 2>&1
rem d:
rem cd d:\sytedb
rem r:\dlc91d\bin\_mprshut.exe symix -by
echo backup the ai files at %DATE% %TIME% >> c:\temp\backup.log
copy z:\symix.a* z:\ai.backup /y >> c:\temp\backup.log 2>&1
echo disable ai at %DATE% %TIME% >> c:\temp\backup.log
call R:\Syte6\ksb\batch\z-disable-ai.bat >> c:\temp\backup.log 2>&1
rem d:\dlc91d\bin\rfutil symix -C aimage end
echo backup syteline at %DATE% %TIME% >> c:\temp\backup.log
call R:\Syte6\ksb\batch\z-backupsyteline.bat >> c:\temp\backup.log 2>&1
rem r:\dlc91d\bin\probkup.bat d:\sytedb\symix Z:\symix -verbose
rem starting database with ai
echo start ai at %DATE% %TIME% >> c:\temp\backup.log
start /wait R:\Syte6\ksb\batch\z-begin-ai.bat
rem d:
rem cd d:\Sytedb
rem d:\dlc91d\bin\rfutil symix -C aimage begin >> c:\temp\backup.log 2>&1
echo wait 30 seconds to give ai begin time to finish before starting database at %DATE% %TIME% >> c:\temp\backup.log
r:\temp\wait 30
echo start styeline at %DATE% %TIME% >> c:\temp\backup.log
call R:\Syte6\ksb\batch\z-startsyteline.bat
rem r:\dlc91d\bin\proserve symix -pf r:\syte6\db\symix.pf -aistall >> c:\temp\backup.log 2>&1
************************************************************************
Backup.log
shutdown the database at Thu 06/14/2012 15:01:56.65
R:\Syte6\ksb\batch>d:
D:\>cd d:\sytedb
D:\Sytedb>r:\dlc91d\bin\_mprshut.exe symix -by
Shutdown is executing. (1613)
Shutdown complete. (1614)
backup the ai files at Thu 06/14/2012 15:01:58.76
z:\symix.a1
1 file(s) copied.
disable ai at Thu 06/14/2012 15:01:58.79
D:\Sytedb>d:\dlc91d\bin\rfutil symix -C aimage end
PROGRESS Version 9.1D08 as of Tue Jan 20 17:34:57 EST 2004
After-image disabled. (846)
backup syteline at Thu 06/14/2012 15:01:58.87
PROGRESS Version 9.1D08 as of Tue Jan 20 17:34:57 EST 2004
573359 active blocks out of 573359 blocks in d:\sytedb\symix will be dumped. (6686)
0 bi blocks will be dumped. (6688)
The blocksize is 4096. (6994)
Backup requires an estimated 2.2 GBytes of media. (9285)
Restore would require an estimated 573359 db blocks using 2.2 GBytes of media. (9286)
Backed up 21750 db blocks in 00:00:10
Backed up 52661 db blocks in 00:00:20
Backed up 100232 db blocks in 00:00:30
Backed up 175660 db blocks in 00:00:40
Backed up 247899 db blocks in 00:00:50
Backed up 302358 db blocks in 00:01:00
Backed up 336153 db blocks in 00:01:10
Backed up 370457 db blocks in 00:01:20
Backed up 403947 db blocks in 00:01:30
Backed up 438760 db blocks in 00:01:40
Backed up 470994 db blocks in 00:01:50
Backed up 504993 db blocks in 00:02:00
Backed up 539025 db blocks in 00:02:10
Backed up 573359 db blocks in 00:02:19
Wrote a total of 16898 backup blocks using 2.2 GBytes of media. (9284)
Backup complete. (3740)
start ai at Thu 06/14/2012 15:04:19.43
PROGRESS Version 9.1D08 as of Tue Jan 20 17:34:57 EST 2004
The BI file is being automatically truncated. (1526)
wait 30 seconds to give ai begin time to finish before starting database at Thu 06/14/2012 15:05:19.82
start styeline at Thu 06/14/2012 15:05:49.96
PROGRESS Version 9.1D08 as of Tue Jan 20 17:34:57 EST 2004
15:05:50 BROKER : This broker will terminate when session ends. (5405)
*****************************************************************
The following is the output of the start the database when run directly in a cmd prompt window and is what I would have expected in the backup.log with the backup.log being released.
D:\Sytedb>r:\dlc91d\bin\proserve symix -pf r:\syte6\db\symix.pf -aistall
PROGRESS Version 9.1D08 as of Tue Jan 20 17:34:57 EST 2004
15:17:38 BROKER : This broker will terminate when session ends. (5405)
15:17:38 BROKER 0: File z:\symix.a1 is on a remote device. (9466)
15:17:38 BROKER 0: Multi-user session begin. (333)
15:17:38 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
15:17:38 BROKER 0: Physical Redo Phase Completed at blk 0 off 1752 upd 0. (7161
)
15:17:38 BROKER 1: Started for syteline using TCP, pid 5952. (5644)
15:17:38 BROKER 1: This is an additional broker for this protocol. (5645)
15:17:38 BROKER 1: This broker supports both 4GL and SQL server groups. (8865)
I am trying to create a bat file to run each night to:
1. take down my database that has ai
2. backup my ai file (I only have 1 variable length file)
3. backup my database (about 2gb in size, takes about 3 minutes)
4. restart my database with ai
Below is my script. The rem'd lines represent the lines of code in the called bat files. The batch file works well until it gets to starting the database. It does start the database but it keeps the backup.log file locked until I take the database down. If I run the start database bat file individually from a cmd prompt then all is well (the backup.log file is not locked). Below the script is the data found in the backup.log.
Does anyone have any idea why this is happening?
rem Backup steps
echo shutdown the database at %DATE% %TIME% > c:\temp\backup.log
call R:\Syte6\ksb\batch\z-stopsyteline.bat >> c:\temp\backup.log 2>&1
rem d:
rem cd d:\sytedb
rem r:\dlc91d\bin\_mprshut.exe symix -by
echo backup the ai files at %DATE% %TIME% >> c:\temp\backup.log
copy z:\symix.a* z:\ai.backup /y >> c:\temp\backup.log 2>&1
echo disable ai at %DATE% %TIME% >> c:\temp\backup.log
call R:\Syte6\ksb\batch\z-disable-ai.bat >> c:\temp\backup.log 2>&1
rem d:\dlc91d\bin\rfutil symix -C aimage end
echo backup syteline at %DATE% %TIME% >> c:\temp\backup.log
call R:\Syte6\ksb\batch\z-backupsyteline.bat >> c:\temp\backup.log 2>&1
rem r:\dlc91d\bin\probkup.bat d:\sytedb\symix Z:\symix -verbose
rem starting database with ai
echo start ai at %DATE% %TIME% >> c:\temp\backup.log
start /wait R:\Syte6\ksb\batch\z-begin-ai.bat
rem d:
rem cd d:\Sytedb
rem d:\dlc91d\bin\rfutil symix -C aimage begin >> c:\temp\backup.log 2>&1
echo wait 30 seconds to give ai begin time to finish before starting database at %DATE% %TIME% >> c:\temp\backup.log
r:\temp\wait 30
echo start styeline at %DATE% %TIME% >> c:\temp\backup.log
call R:\Syte6\ksb\batch\z-startsyteline.bat
rem r:\dlc91d\bin\proserve symix -pf r:\syte6\db\symix.pf -aistall >> c:\temp\backup.log 2>&1
************************************************************************
Backup.log
shutdown the database at Thu 06/14/2012 15:01:56.65
R:\Syte6\ksb\batch>d:
D:\>cd d:\sytedb
D:\Sytedb>r:\dlc91d\bin\_mprshut.exe symix -by
Shutdown is executing. (1613)
Shutdown complete. (1614)
backup the ai files at Thu 06/14/2012 15:01:58.76
z:\symix.a1
1 file(s) copied.
disable ai at Thu 06/14/2012 15:01:58.79
D:\Sytedb>d:\dlc91d\bin\rfutil symix -C aimage end
PROGRESS Version 9.1D08 as of Tue Jan 20 17:34:57 EST 2004
After-image disabled. (846)
backup syteline at Thu 06/14/2012 15:01:58.87
PROGRESS Version 9.1D08 as of Tue Jan 20 17:34:57 EST 2004
573359 active blocks out of 573359 blocks in d:\sytedb\symix will be dumped. (6686)
0 bi blocks will be dumped. (6688)
The blocksize is 4096. (6994)
Backup requires an estimated 2.2 GBytes of media. (9285)
Restore would require an estimated 573359 db blocks using 2.2 GBytes of media. (9286)
Backed up 21750 db blocks in 00:00:10
Backed up 52661 db blocks in 00:00:20
Backed up 100232 db blocks in 00:00:30
Backed up 175660 db blocks in 00:00:40
Backed up 247899 db blocks in 00:00:50
Backed up 302358 db blocks in 00:01:00
Backed up 336153 db blocks in 00:01:10
Backed up 370457 db blocks in 00:01:20
Backed up 403947 db blocks in 00:01:30
Backed up 438760 db blocks in 00:01:40
Backed up 470994 db blocks in 00:01:50
Backed up 504993 db blocks in 00:02:00
Backed up 539025 db blocks in 00:02:10
Backed up 573359 db blocks in 00:02:19
Wrote a total of 16898 backup blocks using 2.2 GBytes of media. (9284)
Backup complete. (3740)
start ai at Thu 06/14/2012 15:04:19.43
PROGRESS Version 9.1D08 as of Tue Jan 20 17:34:57 EST 2004
The BI file is being automatically truncated. (1526)
wait 30 seconds to give ai begin time to finish before starting database at Thu 06/14/2012 15:05:19.82
start styeline at Thu 06/14/2012 15:05:49.96
PROGRESS Version 9.1D08 as of Tue Jan 20 17:34:57 EST 2004
15:05:50 BROKER : This broker will terminate when session ends. (5405)
*****************************************************************
The following is the output of the start the database when run directly in a cmd prompt window and is what I would have expected in the backup.log with the backup.log being released.
D:\Sytedb>r:\dlc91d\bin\proserve symix -pf r:\syte6\db\symix.pf -aistall
PROGRESS Version 9.1D08 as of Tue Jan 20 17:34:57 EST 2004
15:17:38 BROKER : This broker will terminate when session ends. (5405)
15:17:38 BROKER 0: File z:\symix.a1 is on a remote device. (9466)
15:17:38 BROKER 0: Multi-user session begin. (333)
15:17:38 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
15:17:38 BROKER 0: Physical Redo Phase Completed at blk 0 off 1752 upd 0. (7161
)
15:17:38 BROKER 1: Started for syteline using TCP, pid 5952. (5644)
15:17:38 BROKER 1: This is an additional broker for this protocol. (5645)
15:17:38 BROKER 1: This broker supports both 4GL and SQL server groups. (8865)