15.00 - Customization Options - System Emulation Tool

Teradata System Emulation Tool User Guide

System Emulation Tool
User Guide

Customization Options

Use the Customize tab to set options such as whether to create a log file.

Note: It is not necessary to connect to Teradata Database for this procedure.

To set session defaults

1 From the main window, select Tools > Options.

The Options dialog box appears with the Customize tab selected by default.


2 Select one or more of the check boxes under Options.




Create log file

Record all operations performed during an active Teradata SET session. Use the log file to research an operation. For example, research what occurred during an import operation when the import is partially successful.

Log SQL statements

Create a log file of the SQL statements used in the export, import, and undo import (cleanup) processes.

Display logon dialog at startup

Connect automatically to the selected Teradata Database. The Teradata Database Connect dialog box appears.

Provide Audible Notification

Emit a tone when an event is initiated; for example, when a file is exported.

Note: Click on the toolbar to toggle the audible notification on or off.

Use X views (QCD only)

Retrieve data from the QCD using X views.

See “Creating Restricted Views” on page 54 for information on restricted views.

Use X views (DBC and QCD)

Retrieve Data Dictionary information and QCD data using X views.

See “Creating Restricted Views” on page 54 for information on restricted views.

Use Multi-Threading

Speed up export and import operations with multiple connections.

Use SQL Assistant instead of the Execute SQL window with ODBC connectivity

Use SQL Assistant instead of Execute SQL as the query editor when connected to the Teradata Database with ODBC connectivity.

Note: When using a CLIv2 connection, Execute SQL is used regardless of how this option is set.

Export table data used by query optimization

Export table data used by query optimization along with the execution plan.

Note: When this option is selected, table data used by query optimization is retrieved and stored in Teradata SET export files. Table data might be needed to accurately emulate a query plan if the source table of a join has a single‑row access using a unique index because the Optimizer retrieves this row and uses the column values for cardinality estimations. Execution plans must be exported in order to use this function. See “Export Options” on page 79 for more information on exporting execution plans.

Import table data used by query optimization

Insert table data used by query optimization to tables on the test system.

Capture date specific execution plan information

Execution plan information is captured for a specific date when queries using the function CURRENT_DATE are added for export. The Date drop-down list is active when this option is selected.

This option works when DUMP EXPLAIN or INSERT EXPLAIN SQL statements are used to capture the execution plan information.

Export Plans in XML

For queries entered by user, export execution plans in XML format by submitting INSERT EXPLAIN in XML.


Export Dynamic Plans

For queries entered by a user, export Dynamic Plans (IPE - Incremental Planning and Execution) captured into the SystemFE.Opt_XMLPlan_Table by submitting DIAGNOSTIC DUMP XMLPLAN <SystemName> REQUEST <RequestName> ‘comment string’ ON FOR REQUEST; <request>;

Note: Export Plans in XML and Export Dynamic Plans are mutually exclusive options. Select either option for a manually entered query. Either a dynamic plan or a QCD XML plan can be captured.

3 Click Apply.

4 [Optional] To continue customizing a session, select another tab in the Options dialog box.

5 To return to the main window, click OK.