Cleanup History - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
cev1468860002862.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

The Cleanup History dialog enables you to delete SQL History records based on selected criteria

Option Description
Delete SQL History using a criteria Enables you to delete records based on the following criteria:
  • Date deletes records from the SQL History view when the Timestamp column value is less than the selected date.
  • Source deletes records from the SQL History view when the Source column matches the entered value
  • SQL Statement deletes records from the SQL History view when the SQL Statement column is a super set of the entered value.
  • Notes deletes records from the SQL History view when the Notes column is a super set of the entered value.
  • User ID deletes records from the SQL History view when the User ID column matches the entered value.
  • Queries that failed deletes records from the SQL History view when the query execution failed.
  • Rows with empty Notes deletes records from the SQL History view when the Notes column value is empty.
Delete duplicate queries in SQL History Deletes duplicate SQL query records from the SQL History view.
Compact unused disk space allocated by SQL History Releases allocated disk space not used by the SQL History view. After the command executes, you must restart the application to make the disk space available.