15.00 - Perform File Management - System Emulation Tool

Teradata System Emulation Tool User Guide

prodname
System Emulation Tool
vrm_release
15.00
category
User Guide
featnum
B035-2492-034K

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)