Customization Options - System Emulation Tool

Option

Description

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 52 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 52 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 77 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>;