Content Management and Capture

 View Only
  • 1.  Is there any impact if I delete "taskstats table values periodically?

    Posted Thu March 17, 2022 03:23 AM
    Hi Team,

    I hope we are all healthy always

    I want to ask something to make sure

    For example I have
    1. ABC App
    2. ABCEng.mdb and ABCAdm.mdb

    in ABCEng.mdb there is a "taskstats table", where there are batches (a,b,c,d,e,f,g,H)

    If I delete batches (a,b,c,d,e,f,g) and I don't delete (H) in the "taskstats table" -- batch deletes aim to reduce memory

    Question :
    1. Does it affect the application of ABC in production? especially if I do it regularly (eg every month)
    2. Is there any impact if I delete "taskstats table values periodically?
    3. is there any other table I can delete in ABCEng.mdb or ABCAdm.mdb ?

    Thanks


    ------------------------------
    Lintang Gilang
    ------------------------------


  • 2.  RE: Is there any impact if I delete "taskstats table values periodically?

    Posted Tue May 24, 2022 11:41 PM
    Our project has been truncating TASKSTATS table every week. So far no repercussion. I think you can do so periodically without any worry.
    Seriously, Datacap should introduce an option that allows for not inserting into this TASKSTATS.
    It seems utter useless unless the project uses Report functionality.

    ------------------------------
    dsakai
    ------------------------------



  • 3.  RE: Is there any impact if I delete "taskstats table values periodically?

    InnerCircle
    Posted 29 days ago
    We have been keeping a retention of 10 days on taskstats, audit and debug tables for over a year now and have never run into any issues.

    ------------------------------
    Samuel Neville
    ------------------------------



  • 4.  RE: Is there any impact if I delete "taskstats table values periodically?

    Posted 3 days ago
    In Datacap 9.1.9 there is a new action for Maintenance Manager 
    https://www.ibm.com/docs/en/datacap/9.1.9?topic=documentation-whats-new-in-datacap-version-919

    Maintenance Manager improvements

    We have introduced a database cleanup action to cleanup orphan records in the taskstatstable. The cleanup should be scheduled to run periodically during off hours time.

    For instructions on how to run database cleanup, see ProcessDeleteTaskStatsData



    ------------------------------
    Martin Pistora
    ------------------------------