Purpose
Truncates old history rows from TDMaps tables. Periodically run this procedure to prevent historical data from consuming an excessive amount of space.
Syntax
CALL [TDMaps.] TruncateHistorySP ('OlderThan', :NumDeletedRows) [;]
- TDMaps.
- The name of the database.
- 'OlderThan'
- Deletes TDMaps history data older than the specified time. It cannot be NULL.
- :NumDeletedRows
- The output parameter for the number of deleted rows in ActionHistoryTbl, LogTbl, and AnalyzeLogTbl.