16.10 - About the Phases of the Target-Level Emulation Process - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

The extraction of Optimizer cost value information from a target system and its subsequent application to a test system is a two-phase process, as follows.

  1. Data capture phase.

    Target system optimizer variables are read from the Dictionary and various system tables and written to a staging area.

    This phase is initiated from the target system.

  2. Application phase.

    The captured data in the staging area is exported to the appropriate Dictionary and system tables on the test system.

    This phase can be initiated from either the target or the test system.

You can use the Teradata System Emulation Tool from a client system to perform this data capture and application. See Teradata System Emulation Tool User Guide for details

If you do not use Teradata System Emulation Tool, then you must follow a more circuitous path to capture target system optimizer variables and apply them to a test system. This chapter presents both procedures.