• 1 reply
  • Latest Post - ‏2013-05-03T12:15:56Z by DanielWagemann
10 Posts

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


  • DanielWagemann
    850 Posts

    Re: how to trace database


    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.