Topic
  • 1 reply
  • Latest Post - ‏2018-03-06T18:34:25Z by jefflong_wipro
KirillDrozdov1
KirillDrozdov1
28 Posts

Pinned topic Clear session_history table

‏2018-01-24T15:32:55Z |

Hello, community,

session_history table uses 500GB of disk space in production environment. What is the best way to clean it up?

  • jefflong_wipro
    jefflong_wipro
    21 Posts

    Re: Clear session_history table

    ‏2018-03-06T18:34:25Z  

    Hello,

     

    You would want to take appropriate backups and test this thoroughly, but this is something that can be done via the Platform Maintenance Scheduler in TRIRIGA Admin Console.  You can develop SQL to do the cleanups as they meet your business requirements and add that as a new cleanup command at the bottom section of the screen/window and then add a new Cleanup Schedule event in the top section of the screen/window to have it run periodically.

     

    This may be something that you want to reach out to a business partner for assistance with depending on your skill and comfort level in implementing such a change.  If so, you can search IBM's Partner Portal here:

    https://www-356.ibm.com/partnerworld/wps/servlet/ContentHandler/find-partner-solution

     

     Thanks