This content has been marked as final. Show 3 replies
1. How to find where the logfiles are ?If you didn't set the Logdir DSN parameter, the logs file will be placed in DataStore=/timesten/TimesTen/tt1122/info/ana/ana
2. And how to clear them , can I remove them?I don't think that it is possible, because you can corrupt the DB and lost some transactions. Don't do that (see the 3 answer).
3. In using TT, I want to generate least amount of log size in logfile, can I do it ?You can specify different log files attributes:
1. You can set the LogFileSize in 8 MB instead of 64MG (default value).
2. Set LogPurge=1, in this case TimesTen automatically removes transaction log files when they have been written to both checkpoint files and there are no transactions that still need the transaction log files' contents.
I hope this help.
Thanks very , you're so kind.
Your problem here is that you basically don't have enough space allocated in the file system. Once you run out of space like this it is tricky to recover cleanly. As Gennady daid, you should never remove log files manually as you will almost certainly end up with an unusable database. The solution is to avoid this situation by (a) having adequate space in the file system and (b) making sure you are checkpointing often enough to clear the log files. Note that if you are using replication, AWT cacheing or XLA then these can also affect log purging. Note that LogPurge=1 is the default setting so based on your posted DSN settings you are already running with that set.