Perform File Management - System Emulation Tool

Teradata System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-07
dita:mapPath
lth1488824663584.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities

Teradata SET captures emulation information in a variety of file types, as described in the table below. All of the files created during export, import, and pack operations are saved in the file and directory specified under Export to in the Export from Teradata Database dialog box. All exported parameters are stored in a control (.mcf) file that:

  • Tracks elements (such as the object definition) that are selected and exported
  • Contains pointers to the raw data files that are created during the export process
  • Contains a version number, release number, and the date and time the system information was exported from the target data source
Teradata SET File Extensions 
File Type File Extension Saved During
Cleanup files .undo Import
Control information .mcf Export
Cost parameters, DBS Control parameters, and cost profiles .opt Export
Demographics .dem Export
Execution plans and workloads .qcd Export
Log files .log
  • Export
  • Import
  • Undo (cleanup)
Object definitions .ddl Export
Packed files .pack Pack
RAS .ras Export
SQL statements .sql Export
Statistics .col Export
Summary reports .rpt
  • Export
  • Import
  • Undo (cleanup)