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.
- 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, selectto 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.
|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.|
|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.|
|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
|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.|