Export Methods and Options - System Emulation Tool

Teradata® System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-19
dita:mapPath
log1544831946868.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities

Teradata SET is used to quickly capture (export) emulation information, which can be edited, and then import the information to a test system in order to imitate the target system. For example, using system information exported from a target system with four nodes, cost parameters and execution plans can be analyzed on the test system as if it also has four nodes. See Import Methods and Options.

The Export feature can be customized to ensure that the test system imitates the features of the target system being analyzed (see Export Options). The steps below provide an overview of the export process:

  1. Before exporting emulation data, connect to the database. See Connect to the Database.
  2. Select an export method:
    • Query: To identify database objects for export using one or more data manipulation language (DML) statements. See Export by Query.
    • Database: To select database objects for individual export. See Exporting by Database.
    • Workload: To identify database objects for export based on an existing workload definition. See Exporting by Workload.
  3. Customize the export operation. See Export Options.
  4. Export the information needed to emulate the target environment on the test system.
The following topics explain how to use Teradata SET to capture information from a target system: