Target Level Emulation and Cost Profiles - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

To enable optimizer cost profile system DIAGNOSTIC statements in combination with Target Level Emulation, you must set the EnableCostProfileTLE parameter of DBS Control to TRUE.

If the DBS Control parameter EnableSetCostProfile is set to 0, Teradata Database automatically sets EnableCostProfileTLE to FALSE. This cannot be changed independently.

To solve the problem, ensure that the EnableSetCostProfile parameter is set to a value other than 0 and then set the EnableCostProfileTLE parameter to TRUE.