Kbase 36164: How to truncate a database log file
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Solution ID: P6164
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>
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.