Automated Housekeeping of Cognos Metadata

I’m a little new to administration of Cognos and am looking to improve the processes currently being used within our environment.

Our Metadata appears to be growing out of control (100Gb database now living on SQL Server) and was wondering if there are any good/best practices for maintaining the Metadata keeping it clear from clutter and auto archive to file system any logs older than x.

Any help with this would be greatly appreciated.

Regards,

Marcus

Hi Marcus,

i’m not sure it you mean the temp directories in the installation directories of Cognos or your content store on the SQL database…

content store cleanup scripts
http://www.cogknowhow.com/index.php/library/70-cognos-8-database-cleanup-scripts-

if you mean RTmodels take a look at this
http://www.cogknowhow.com/index.php/knowledge-articles/30-cognos-8/366-what-are-rtmodels-