Here is an easy to use tool with which can cleanup the Cognos audit database. The tool can be used to purge the old audit database records regularly based on a timestamp.
http://www-01.ibm.com/support/docview.wss?uid=swg24036642
http://www-01.ibm.com/support/docview.wss?uid=swg24036642