Product Documentation
Abstract
Modifying cascading deletion of qstats table is not recommended since it impacts the performance of Job Monitor.
Content
When you run the daily Maintenance Manager task for cleaning the backlog of Job Done and Split Done batches, the task cleans the batches from the batch directory and queue table.
If you modify cascading deletion on qstats table, the qstats records are not deleted during the clean-up operation. When the qstats table grows significantly, the performance of Job Monitor is severely impacted.
Hence it is highly recommended to not modify cascading deletion of qstats table.
If you modify cascading deletion on qstats table, the qstats records are not deleted during the clean-up operation. When the qstats table grows significantly, the performance of Job Monitor is severely impacted.
Hence it is highly recommended to not modify cascading deletion of qstats table.
Document Location
Worldwide
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSZRWV","label":"IBM Datacap"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.1.6","Edition":"Interim Fix 002","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
08 September 2020
UID
ibm11074801