Deleting log-files older than < x > days with TI

Ideas and tips for enhancing your TM1 application
Post Reply
Marcus Scherer
Community Contributor
Posts: 126
Joined: Sun Jun 29, 2008 9:33 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016
Location: Karlsruhe

Deleting log-files older than < x > days with TI

Post by Marcus Scherer »

At the costumer site no admin ever observed and probably never will observe the log-files. Thus they can be regularly deleted, assuming a regular backup of the log directory on tape is in place! Maybe you're interested in it.

- valid for the actual decade (searching for "tm1s201*.log")
- Windows OS
Attachments
602_delete_log_files.pro
(1.69 KiB) Downloaded 1009 times
User avatar
Mike Cowie
Site Admin
Posts: 482
Joined: Sun May 11, 2008 7:07 pm
OLAP Product: IBM TM1/PA, SSAS, and more
Version: Anything thru 11.x
Excel Version: 2003 - Office 365
Location: Alabama, USA
Contact:

Re: Deleting log-files older than < x > days with TI

Post by Mike Cowie »

Marcus:

Thanks for posting this. There are also some DOS-based ways of doing this, too, if you'd like to use some other non-TI scheduler, or would like to use a single batch file/command from TI (using ExecuteCommand). One of the DOS command methods I've used takes advantage of the Forfiles command and looks something like this (this one clears out Cognos Express logs 21 days or older):

Code: Select all

cmd /c Forfiles -p "C:\Program Files (x86)\IBM\Cognos Express\logs\express" -s -m "*.log" -d "-21" -c "cmd /c del /q @path"
A bit cryptic at first glance, but 1 command takes care of it all.

Some notes on the ForFiles command, if interested in learning more about it:
http://technet.microsoft.com/en-us/libr ... S.10).aspx

Regards,
Mike
Mike Cowie
QueBIT Consulting, LLC

Are you lost without Print Reports in Planning Analytics for Excel (PAfE)? Get it back today, for free, with Print Reports for IBM Planning Analytics for Excel!
BigG
Community Contributor
Posts: 211
Joined: Tue Sep 15, 2009 11:13 pm
OLAP Product: IBMPA
Version: PA 2.0 Cloud
Excel Version: 2010

Re: Deleting log-files older than < x > days with TI

Post by BigG »

Hi there, just jumping in on this post, if you run that cmd arethere any .log files that are located in C:\Program Files (x86)\IBM\Cognos Express\logs\express that you would want to consider retaining?

Note we are on cognos express too
GG
User avatar
ADW
Posts: 32
Joined: Tue Jun 14, 2011 11:10 am
OLAP Product: Cognos Express
Version: 9.5
Excel Version: 2010
Location: Cheshire, England

Re: Deleting log-files older than < x > days with TI

Post by ADW »

This question has just popped up for us.

We want to delete older log files but are not sure which ones we need to keep hold of.

Also have Cognos Express.
BigG
Community Contributor
Posts: 211
Joined: Tue Sep 15, 2009 11:13 pm
OLAP Product: IBMPA
Version: PA 2.0 Cloud
Excel Version: 2010

Re: Deleting log-files older than < x > days with TI

Post by BigG »

Hi ADW, we ended up just going for every .log file 3 weeks or older deleted once a week using the script from Marcus. Also restart service at same time
GG
User avatar
ADW
Posts: 32
Joined: Tue Jun 14, 2011 11:10 am
OLAP Product: Cognos Express
Version: 9.5
Excel Version: 2010
Location: Cheshire, England

Re: Deleting log-files older than < x > days with TI

Post by ADW »

Thanks for that.

I was worried that deleting the cogserver.log file would cause a problem, but I guess that file never gets older than the last time Cognos was used.
Post Reply