16.10 - About the Transfer History View - 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 Teradata Transfer History view provides an enhanced display of the Data Transfer History information in the database. As data transfers are performed, an entry is placed in the Transfer History. The Transfer History view displays the data in a grid format that enables you to select rows or cells.

The Transfer History view provides extensive information about the data transfer event, such as the name, start time, rows transferred, source and destination systems, status (Completed, Canceled, or Failed), and summary. It provides options to:
  • Copy selected cells to the clipboard
  • Sort columns
  • Delete rows
  • Edit "Note" or "Name" for a history entry
  • Filter columns
  • Search for transfer history data
  • Hide and show columns
  • Auto-resize columns or rows
  • Display the job output for a History entry

The Transfer History view uses an embedded Derby Database to manage the Transfer History entries.

If you close the view, select Window > Show View > Transfer History View to reopen the view.

You can add notes manually by selecting the Transfer History View Note entry and in the toolbar clicking Edit Note. In the Transfer History Note dialog, type the note you want added to the Transfer History View entry.

All columns are sortable in ASC/DSC order with the exception of the parameters column. The columns are sorted by left clicking the mouse button. This is for single column sorting only.

Columns are movable by selecting the column and dragging it to the new location. Columns are also re-sizable. Rows can be selected by clicking in the numbered row header.

If a filter is in effect, the result of a newly executed data transfer is inserted at the top row, regardless of whether it meets the filter criterion. If a sort is in effect the new entry is inserted in the sorted order.

The Summary column contains a brief summary of the data transfer, such as the source database and table names. The Job Output can be displayed by selecting the history entry and clicking Show Job Output in the toolbar. Failed data transfers display as red text in the Status column.

Toolbar Actions

Icon Option Description
Edit name Click to edit the name of the transfer history entry.
Edit note Click to edit the note field of the transfer history entry.
Delete selected row(s) Click to delete selected row(s) from the view and transfer history database.
Filter display Click to open a dialog to filter display.
Clear filter Click to clears the filter and refresh the transfer history display.
Show job output Click to show the job output.

Toolbar Menu

Icon Option Description
Edit Name Click to edit the name of the transfer history entry.
Edit Note Click to edit the note of the transfer history entry.
Delete Selected Row(s) Click to delete selected row(s) from the view and transfer history database.
  Delete All Transfer History Click to delete all entries in the transfer history database.
Filter Click to open a dialog to Filter display.
Clear Filter Click to remove the current filter from the display.
Reexecute Click to execute the selected data transfer job in the Transfer History list.
Show Transfer Job Output Click to display the job output for the selected data transfer job.

Column Headers

Column Name Description
Name Name of the transfer job.
Timestamp Time of transfer event. Format is yyyy-mm-dd hh:mm:ss.mm.
Source Profile name for database that was the data source for the transfer.
Destination Profile name of the database to which the data was transferred.
Status Status of the transfer event.
Duration Length of time required to transfer data between the source and destination. The format is hh:mm:ss.mm.
Rows Transferred Number of table rows transferred.
Note Text notes about transfer event.
Summary Technical summary describing transfer source and destination paths.

Column Header Context Menu

Right-click a column header to hide, show, and resize columns. You can also use the Find feature to locate data in column rows.
Icon Option Description
Hide column Hides the current column.
Show all columns Shows all columns.
Auto resize column Resizes the current column.
Find Displays the Find dialog to search rows in the column for a value. - Searches the Transfer History View for a value.