Kbase 19674: How to control database log file growth?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/25/2008 |
|
Status: Unverified
GOAL:
How to control database log file growth?
GOAL:
How to truncate database log file when PROLOG cannot be used?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
The Progress PROLOG utility cannot truncate a database log while the database is running. The following code will automatically check the size of the log file and truncate it if the log exceeds a specified size.
This code will run only when the database server is started, but experience has shown that even 24x7 sites shut down their database at least every six months for system or other outages:
# Start Databases
#
# First check to see if the database .lg file is too large
SIZE=`ls -ls dbname.lg | awk '{ print $1 }'`
if [ $SIZE -gt 10240 ] # if lg file is > 5 MB
then
prolog dbname.lg
fi
$DLC/bin/proserve dbname -B ......