Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2013-05-03T12:15:56Z by DanielWagemann
rockay
rockay
10 Posts
ACCEPTED ANSWER

Pinned topic how to trace database

‏2013-05-03T08:57:59Z |

Hello ,

Does any friend know howto trace the audit database? in fact I am not sure my audit db work fine or not, sometime I can't see the record(not sure the reason). So want to ask you if you know Cognos has a UDA-like trace for audit data base. Because I found UDA trace is very detail that can know everything I expect from it

Thanks

  • DanielWagemann
    DanielWagemann
    850 Posts
    ACCEPTED ANSWER

    Re: how to trace database

    ‏2013-05-03T12:15:56Z  in response to rockay

    If you are looking to troubleshoot reports that are reporting off the audit database then the standard UDA traces or native driver traces apply.

    If you are looking to troublehoot the records being written to the aduit database you can either trace the JDBC driver that is being used by cognos to connect to the audit database or capture the sql on the database by filtering on the application or uid which corresponds to the one used by Cognos.