Kbase 13104: How to Automate Version 6 and 7 NLM DB Shutdown for Backup
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/21/2003 |
|
Status: Technically Reviewed
GOAL:
How to bring down the NLM database automatically so that a backup can be performed.
FACT(s) (Environment):
Progress 6.x
FACT(s) (Environment):
Progress 7.x
FIX:
There is no online backup with Progress Version 6.x and 7.x NLM products. In order to backup the database files (.db, .bi, .lg), you must bring down the NLM database server first.
Currently, there are 3 methods to bring down the NLM database engine (the first two are the recommended way):
- Issue a SHUTDOWN at the NLM Server's screen.
> shutdown
- Issue a PROSHUT from a client machine.
proshut dbname -S servicename -N spx
(Please refer to the System Administration Guide for more
detailed information on the PROSHUT command.)
- Issue an unload _mprotli (Version 6.x) or unload _mprosrv
(Version 7.x) at the Novell server's console prompt.
NOTE: Issuing an unload at the console prompt unloads all
Progress NLM servers that are running at the time.
Automating the startup/shutdown process:
At the time of this writing (1994), Novell does not ship any
utilities that allow you to issue console commands at
particular times with their core product.
There are many 3rd party products that allow you to do this.
Contact your local software vendor and ask for information
on this type of automation product. Many NetWare backup products
(Cheyenne ArcServe, Computer Associates ARCserveIT, Legato
Networker, NT Backup, Arcada Backup, Seagate Software Backup,
Veritas Backup) allow "pre" and "post" backup execution of NCF
files (refer to the manual for your backup software).
Once you purchase a product that allows you to either run .ncf
files (Novell 'batch' files) or issue console commands at
particular times, you can automate the process.
For shutdown, configure your 'automation' software to go to the
NLM server screen and issue a shutdown or have it issue an unload
command at the server prompt.
Remember that you can also issue a PROSHUT command from a
client machine. So if you have a DOS TSR that allows you to
run batch files at certain times of day, you could configure
it to run a batch file that issues the PROSHUT command.
For startup, configure your 'automation' software to run a .ncf
file that you create and that has your NLM startup line. Make
sure you allow enough time between shutdown and startup for the
backup to complete.
The advantage of using the "pre" and "post" backup options
directly from your backup software is that conflicts with the
timeframe for the backup are avoided. It automatically shuts down
the database before the backup, and restarts it when the backup
is finished.