16.10 - Cleanup History - Teradata Studio

Teradata Studio Express User Guide

prodname
Teradata Studio
vrm_release
16.10
created_date
June 2017
category
User Guide
featnum
B035-2042-067K

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.