Page 1 of 1
Large LOG files in Cognos Express
Posted: Tue Oct 15, 2013 6:47 am
by sun
Hi,
i have problem. Each save date gnerate very large txt (log file). For example
tm1s201315101233.txt
This files are almost 250 MB large.
I have save data on 50 minutes.
I think that is generated by save data. I'm using cognos express 10.1.
Any idea?
Thank you.
Re: Large LOG files in Cognos Express
Posted: Tue Oct 15, 2013 6:58 am
by failurehappening
A quick google search "tm1 tm1s.log savedata" first link:
http://pic.dhe.ibm.com/infocenter/cbi/v ... rview.html
To save all changes to the data on a Cognos TM1 server at any time without shutting down the server, right-click a server in Server Explorer and Click Save Data. All records in the Tm1s.log file are immediately written to disk, the transaction log file is renamed by appending a date/time stamp to it, and a new Tm1s.log file is created to accept any subsequent edits to cube values.
The problem you have is not with the log files...
Re: Large LOG files in Cognos Express
Posted: Tue Oct 15, 2013 7:02 am
by sun
Ok, so what can i do to avoid this tm1s....txt files.
thank you for replay.
Re: Large LOG files in Cognos Express
Posted: Tue Oct 15, 2013 7:13 am
by declanr
Sun,
You are exactly correct and this is occurring because of your savedata points.
TM1 needs to do something with all of the transactions it has recorded so that is where they go, you can make the files smaller by logging less data... if you have logging turned on for cubes that you do large data loads from source into then you can turn off the logging in the prolog and back on in the epilog.
However it is very possible that you are logging exactly the correct amount of information you need.
The usual approach is to have scheduled tasks that go through that folder and zip up the old files and move them elsewhere (and possibly delete the older ones)... a search of the forum will show you a number of topics about how to do just that.
HTH