Control Manager (TMCM) also stores Command Tracking logs which cannot be purged via the console. This leads to a substantial growth in the database size.
To purge the Command Tracking logs:
- Open the SQL Query.
- Stop the TMCM Services.
- Run the following scripts in SQL query: If the TMCM server is a Child server in a cascading environment, and is scheduled to perform Upload Logs at a certain schedule, the logs being uploaded to the Parent CM server will be lost if the tb_templog is truncated.
truncate table tb_tvcscommandlist;
truncate table tb_tvcsCommandTaskqueue;
truncate table tb_commanditemtracking;
truncate table tb_commandtracking;
Backup log db_controlmanager with truncate_only;
exec sp_dboption 'db_controlmanager', 'trunc. log on chkpt.', 'TRUE';
exec sp_dboption 'db_controlmanager', 'autoshrink', 'TRUE'; - Restart the TMCM Services.
You can also change the automatic purge settings for the Command Tracking logs (90 days for CommandTracking and 24 hours for CommandTaskQueue) in the SystemConfiguration.xml file:
- CommandItemTracking and commandTracking are configured in "m_iCommandTrackingLogPurgeRange".
- CommandTaskQueue table is configured in "m_iCommandQueueTimeOut".
Restart the TMCM services after changing the settings in the XML file.