Hi All,
As on subject, I am wondering if the database log file (*.lg) can be set to either one of this mode, 'append', 'overwrite' or 'create new'?
I have tried searching on KB, community and documentation but not able to find the answers.
Kindly advise.
Thank you.
Regards,
Tai Li
The DB log is simply a continuously appended text file. What discipline you impose externally is up to you.
I found this KB (knowledgebase.progress.com/.../P139345) but is for AppServer Broker log.
No such parameter. The only tool for db.lg maintenance is prolog, as in:
prolog [online] db
See documentation for details.
Paul
The DB log is simply a continuously appended text file. What discipline you impose externally is up to you.
Danger, Danger Will Robinson!
Why would you want to overwrite the log file - it can be your best friend if things go pear shaped.
(And what is the difference between "overwrite" and "create new"?).
N/
Hi [mention:3cb137fff0074190a2d3f32e55cf403a:e9ed411860ed4f2ba0265705b8793d05], ya, I have read about prolog but is for truncating of the log file, which isn't what I am looking for. Thanks for the suggestion though.
Noted [mention:6911e6cc8725416dba58ae08a80faffd:e9ed411860ed4f2ba0265705b8793d05].
Hi [mention:c901b03a10c44d5b951ac1bbbc7d2a23:e9ed411860ed4f2ba0265705b8793d05], my intention was to find out if there are any settings to switch among the possible modes. "Overwrite" meaning that the existing log file will be overwritten by a new day's log file, whereas "Create New" will backup the existing log files and start on a new ones, like how JBoss write its logs:
Example:
server.log // Latest
server.log.2014-02-11
server.log.2014-02-12
server.log.2014-02-13
server.log.2014-02-14
...
In the DB Info Exchange at PUG Challenge Americas there was a discussion of DB log management and an enhancement request for functionality similar to the universal broker/server logs.
For the time being, if you really want daily logs you can write a script to copy db.lg to db_yyyy-mm-dd.lg and then run prolog. Put it in your cron to run at 23:59.
I can't say I'd want daily logs. It would make log file analysis needlessly complicated.
Thanks for this great news [mention:4b133177ec1e4b6f9a6a7832e6f29913:e9ed411860ed4f2ba0265705b8793d05] !