Large LOG files in Cognos Express

Post Reply
sun
Posts: 51
Joined: Thu Feb 02, 2012 8:21 pm
OLAP Product: TM1 Cognos
Version: 9.5
Excel Version: 2003

Large LOG files in Cognos Express

Post 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.
failurehappening
Posts: 78
Joined: Tue Nov 30, 2010 1:18 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Large LOG files in Cognos Express

Post 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...
RHR
sun
Posts: 51
Joined: Thu Feb 02, 2012 8:21 pm
OLAP Product: TM1 Cognos
Version: 9.5
Excel Version: 2003

Re: Large LOG files in Cognos Express

Post by sun »

Ok, so what can i do to avoid this tm1s....txt files.

thank you for replay.
declanr
MVP
Posts: 1828
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Large LOG files in Cognos Express

Post 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
Declan Rodger
Post Reply