Overview - 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
  1. Before importing data, connect to a Teradata Database.
  2. Select an export method. See Export Methods and Options.
  3. Export the information needed to emulate the target environment on the test system. See Export Methods and Options.
  4. Import the information to the test system, modifying the import options if necessary. See Import Methods and Options.
  5. Manage the imported data by doing the following (see Administrative Functions):
    • Remove emulation information.
    • Delete files.
    • Email data to another location.
    • Troubleshoot the import and export processes.

A .mcf file is created when emulation information is exported from a target system. This file includes pointers to the raw data files that are also created during export. During an import operation, the data in these files is applied to the default location specified in the following table.

Default Import Locations 
Import Item Default Import Location Change Location
Cost parameters SystemFE.Opt_Cost_Table and Opt_DBSCtl_Table No
Cost profiles Data Dictionary No
Demographics Export Demographics Source Yes
Execution plans Export QCD Yes
Object definitions Export database Yes
RAS SystemFE.Opt_RAS_Table No
Statistics Data Dictionary No
Workload data Export QCD Yes
Multiple Hash Maps

SystemFE.Opt_Map_Table

SystemFE.Opt_MapRel_Table

No

To change the owner of databases or users, use the Parent Database box in the Import Options dialog box. To change the QCD, use the Target QCD box in the Import Options dialog box. See Changing Import Options.

To change the location or target database where objects are created, use the Rename function in the Import window. See Renaming a Target Database.