16.10 - Enabling Target Level Emulation - Teradata Database

Teradata Database Administration
Product
Teradata Database
Release Number
16.10
Published
April 2018
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
qjg1509413559832.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval
dita:id
ujp1472240543947

Target Level Emulation is disabled by default and should never be enabled on a production system.

The following is a high-level procedure for enabling Target Level Emulation on a test system.

  1. Run the DIP utility script DIPSYSFE to create the optimizer cost values table SystemFE.Opt_Cost_Table, the dynamic AMP sample statistical values table SystemFE.Opt_RAS_Table, the XML-formatted query plans table SystemFE.Opt_XMLPlan_Tbl, and the DBS Control parameters table SystemFE.Opt_DBSCtl_Table.
  2. Use the DBS Control utility to enable Target Level Emulation on your test system by setting DBS Control general parameter Target Level Emulation to TRUE.