Perform File Management - System Emulation Tool

Perform File Management

Teradata SET captures emulation information in a variety of file types, as described in Table 11. 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

Table 11: 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)