Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  Audit database maintenance cleanup SQL script

    Posted Wed October 27, 2021 12:02 PM
    Is there an Audit database maintenance SQL script? That deletes old records from the COGIF tables and ensures integrity between the tables?

    ------------------------------
    Thomas van der Meer
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Audit database maintenance cleanup SQL script

    Posted Thu October 28, 2021 05:29 AM
      |   view attached
    Yes, there is a script you can customize, I attached it to this post

    ------------------------------
    Pierre-Frank MOUZON
    ------------------------------

    Attachment(s)

    zip
    IBM_AuditDBCleanup.zip   139 KB 1 version
    Original Message


  • 3.  RE: Audit database maintenance cleanup SQL script

    Posted Thu October 28, 2021 06:35 AM
    Hi Thomas, 

    See if this thread helps. 

    https://community.ibm.com/community/user/businessanalytics/communities/community-home/digestviewer/viewthread?MessageKey=2f0ec254-1772-46b9-80a3-46aa26465f70&CommunityKey=6b10df83-0b3c-4f92-8b1f-1fd80d0e7e58&tab=digestviewer#bmfb2232dc-7f33-4922-8d82-09dbe560ca6f

    Regards,

    ------------------------------
    Kiran Passumarthi
    www.linkedin.com/in/kiranpassumarthi
    ------------------------------

    Original Message