Kbase P6164: How to truncate a database log file
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
GOAL:
How to truncate a database log file
GOAL:
How to reduce the size of <database>.lg file
FIX:
Running the following command to truncate the database log file:
prolog <database_name>
This command trims and shortens the log file. It saves only the last 3000 bytes.
A good strategy is to save a copy of the current log file prior to truncating it with PROLOG. It may be necessary to reference previous events that occured withing the database when investigating an issue.