Undoing Imported Files - System Emulation Tool

Teradata® System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
hdo1608578450920.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities

After the query plan is analyzed, use the Teradata SET Undo Import feature to undo (cleanup) the imported information that is no longer needed.

Every import creates a corresponding .undo file, which is used to keep the test system uncluttered. Multiple types of information can be removed from a single .undo file, but only one undo import operation is performed at a time.

If objects are cleaned up once using the associated .undo file, they cannot be cleaned up again using the same .undo file.
  1. Connect to the same system used to create the .undo file. See Connect to the Database.
  2. Click .
  3. Select an .mcf file that has an associated .undo file.
  4. Select an .undo file, then click Open.
  5. Click Open.
  6. Under Undo Import Options, select the check boxes for the information to undo (clean up) in the database.
  7. Click Error Handling to change how errors are handled during the undo-import (cleanup) operation.
  8. Click Undo Import.
    If the undo-import (cleanup) operation is only partially successful, an error message appears. If this occurs, open the log file for the operation to diagnose the problem. See Viewing the Log File for the Current Session.
  9. View a summary report for the results.