Hi,
I asked Support what the use of TASKSTATS table was.
The operator told me only Report Viewer used this table.
Why is Datacap always writing into TASKTATS anyway when it is not configured with Report Viewer?
In one project, the size of this table had become like several hundred GB at one time.
I told them what Support told me: Truncate it.
Now in a new project that I am in, I am requesting the client to Truncate it likewise.
But I and the client are wondering if Datacap can stop writing into TASKSTAS table. It seems like a total waste of the resource.
I found these support documents, but not helpful. It does not have steps for v9 and I think Delete immediately after Insert slows down and also causes a big transaction log in MSSQL server.
https://www.ibm.com/support/pages/stopping-inserts-taskstats-table-ibm-datacap-taskmaster-capturehttps://www.ibm.com/support/pages/latency-issues-ibm-datacap-taskmaster-capture------------------------------
dsakai
------------------------------