Kbase P6953: Can I truncate the log file while the database is running?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/02/2009 |
|
Status: Verified
GOAL:
Is there a way to truncate the database log file online ?
GOAL:
How to truncate the .lg file while the database is running.
GOAL:
Can I truncate the database log online
GOAL:
How to truncate a database log online.
GOAL:
Can prolog be run to truncate the database log file while the database is online?
GOAL:
Can the log file be truncated when the database is online ?
FACT(s) (Environment):
OpenEdge 10.1A
All Supported Operating Systems
FIX:
OpenEdge 10.1A introduces the option to run the prolog dbname -online, this option will allow users to truncate the database log while the database is online, it is recommended that this operation is performed while the system is running with low activity.
$ prolog dbname -online
If you need to save the log file before truncation, please archive it using an OS utility prior to using prolog. Please note that at the time of writting, the utility is still limited to 32-bit lseek, so database lg files greater than 2GB cannot be truncated with prolog. See Solution P141193, "Truncating the database lg file with prolog fails"
For previous versions or OpenEdge and database lg files > 2GB please refer to Solution P20131, "How to truncate a database log online."