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.
- Connect to the same system used to create the .undo file. See Connect to the Database.
- Click .
- Select an .mcf file that has an associated .undo file.
- Select an .undo file, then click Open.
- Click Open.
- Under Undo Import Options, select the check boxes for the information to undo (clean up) in the database.
- Click Error Handling to change how errors are handled during the undo-import (cleanup) operation.
- 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.
- View a summary report for the results.