TM1 Log File Cleanup

One of the things that is often overlooked in TM1 is to clean up the log files. There are a few different types of log files, one of which is created every time a SaveDataAll or a CubeSaveData is executed. These save the data in TM1 cubes out to disk, so that if the server crashes, TM1 will be loaded with the last saved data set. Thus you can end up with many of these log files and they can be huge (in gigabytes).

These log files are named in the syntax tm1sYYYYDDMMHHMM.txt, for example tm1s201515111047.txt.

To manage this we need to clean up the old log files. They can be either zipped or deleted, or just deleted.  Personally, I prefer to just delete them when they are older than about 2 weeks.

To do this we use a combination of a Process that is scheduled into a Chore and run every week and a .bat file that is run by the process. In the batch file we then define the location of the log files and how far back we want to delete them.

The Process, Chore and .bat file for cleaning up TM1 Log Files are available here if you’d like to use them in your TM1 or Cognos Express environment.

If you like this post, please spread the love…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.

3 comments on “TM1 Log File Cleanup

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.