Enabling Target Level Emulation - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

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

Before you can use target level emulation on a test system, you must enable it.

The following is a high level procedure for performing this task.

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 22, Target Level Emulation, to TRUE.