Transaction Log Duration

[Andero]

Hi everyone,

Sorry but I couldn't find another post related to this.
I've been asked by a client to increase the transaction log duration.
At the moment it seems that it keeps track for the last 2 weeks and I need to increase it to 30 days.

Is it possible to change it? If Yes, do you know which parameter should I change?

Thanks in advance

[ascheevel]

No parameter for transaction log retention. If you're only seeing 2 weeks of transaction logs, there must be a utility running that's deleting tm1s<datetimestamp>.log files older than a certain time. Theoretically, the transaction log could go as far back as you have saved tm1s log files.

You could search the chores on the tm1 model to see if there's any calling a "cleanup logs" type process or search TI processes that have ExecuteCommand somewhere in the TI and see if it's either calling an exe, batch file, or compiling the command to delete those transaction log files. The sort of command, assuming a windows box, to clear out specific files might be using a "ForFiles" command.

Since we're curious folk, please report back on where you end up finding the culprit.

[Andero]

Hi!

Thank you for your reply.

Indeed I have a nightly chore that cleans the logs older than 2 weeks.. I completely forgot about that.
I will increase it to one month so everything should go fine.

Thanks!

Andrea

[Wim Gielis]

No parameter for transaction log retention. If you're only seeing 2 weeks of transaction logs, there must be a utility running that's deleting tm1s<datetimestamp>.log files older than a certain time. Theoretically, the transaction log could go as far back as you have saved tm1s log files.

You could search the chores on the tm1 model to see if there's any calling a "cleanup logs" type process or search TI processes that have ExecuteCommand somewhere in the TI and see if it's either calling an exe, batch file, or compiling the command to delete those transaction log files. The sort of command, assuming a windows box, to clear out specific files might be using a "ForFiles" command.

Since we're curious folk, please report back on where you end up finding the culprit.

Or the AsciiDelete function in TI without external commands.

[shahhere]

Hi!

Thank you for your reply.

Indeed I have a nightly chore that cleans the logs older than 2 weeks.. I completely forgot about that.
I will increase it to one month so everything should go fine.

Thanks!

Andrea

The log files can be a bit large but once zipped they are not that large. We actually zip the files along with other nightly zips of the Data/Reports/Logs and then delete the logs....its a good idea to keep the zipped up version of the model for 30/60/90 etc.

Shahhere