analytics

Tuesday, January 10, 2012

What's inside Cognos Audit DB tables?

I was (like some of you), curious about what kind of structure does audit database has. I was always interested to find out what's actually getting stored in various tables that I talked about earlier. Well, I've found one link on ibm's website which gives pretty much every information about the tables and the columns it stores in audit database.

It's really helpful if you want to trace the stats and error conditions or maybe to start a deep investigation about your IBM Cognos environment.

The audit table definitions can be read here. Click on individual table to get its column details.

http://publib.boulder.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_cra.10.1.0.doc%2Fug_cra_id56716asg_table_definitions.html

There's a lot to explore here. I'll be doing that in free time and posting about those. Till then, you could go ahead and browse table's structure and define your own ways to use audit database information to get more insight into IBM Cognos's behaviour.