Cleanup History - Teradata Studio

Teradata® Studio™ Express User Guide

Product
Teradata Studio
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-10
dita:mapPath
mub1542649412178.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2042
lifecycle
previous
Product Category
Teradata Tools and Utilities

Use the Cleanup History dialog to delete SQL History records based on selected criteria.

Option Description
Delete SQL History using a criteria 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, restart the application to make the disk space available.