CA Service Management

  • Private Community

  • 1.  Rows are increasing

    Posted Dec 27, 2018 02:05 AM

    For act_log: rows are increasing and how to reduce the number the count.

     

    Kindly advise.

     

     

    Thanks,

     Sohail



  • 2.  Re: Rows are increasing

    Broadcom Employee
    Posted Dec 27, 2018 03:41 AM

    Hi Shaik,

     

    You might want to consider a periodic archive/ purge of the tables that you want to reduce. Below is a technical document for Notification Log table which might be helpful for you to get going for other tables.

     

    https://comm.support.ca.com/kb/how-to-purge-the-notify-log-header-table/kb000038303

     

    Also you might find the below docops to understand the concepts.

     

    https://docops.ca.com/ca-service-management/14-1/en/administering/configure-ca-service-desk-manager/managing-your-database/how-to-archive-and-purge-historical-data

     

    Let me know if this helped? 



  • 3.  Re: Rows are increasing

    Broadcom Employee
    Posted Jan 03, 2019 11:08 AM

    SS00553218........

     

    Did the information provided by Maheshwar_Kusuma address your concern regarding the MDB ACT_LOG table?

     

    If so, please mark the answer as CORRECT so that this thread can be closed.