15.00 - Export Options - System Emulation Tool

Teradata System Emulation Tool User Guide

prodname
System Emulation Tool
vrm_release
15.00
category
User Guide
featnum
B035-2492-034K

Export Options

This section describes the purpose of each check box and explains how to use each option. Check boxes also can be used in combination.

Select check boxes under Export Options, located in the export dialog boxes (Export By Query, Export By Database, and Export By Workload), to define the information exported from a target system. Availability of the check boxes varies according to the type of export selected.

When exporting by query and either typing a query manually or loading a query from a file, the execution plans are captured and exported depending on the options selected for Execution Plans, Export Plans in XML (Customization option), Export Dynamic Plans (Customization option), and Demographics as described below.

 

 

Export Dynamic Plans

Export Plans in XML

Execution Plans

Demographics

Description

Unchecked

Checked

Checked

Unchecked

INSERT EXPLAIN in XML captures the plan into a QCD database and deletes it after the export operation.

Unchecked

Unchecked

Checked

Unchecked

DUMP EXPLAIN captures the plan.

Unchecked

Checked or Unchecked

Checked

Checked

INSERT EXPLAIN captures the plan into a QCD database and deletes it after the export operation.

Checked

Unchecked

Checked

Irrelevant

IPE Plan is captured in SystemFE.Opt_XMLPlan_
Table

During an import operation, the QCD plans are imported into the database listed in the QCD Name box. The DBQL Plans are imported into the external DBQL Database. Dynamic Plans are imported into SystemFE.Opt_XMLPlan_Table.

If the Execution Plans check box is selected and the Export table data used by query optimization check box is selected when customizing options (see “Customization Options” on page 51 for more information), table data used by query optimization is captured.

For more information, refer to SQL Request and Transaction Processing B035-1142.

Click Options, when available, to display the Export Options dialog box and modify the default settings for:

  • Cost parameters
  • Cost profiles
  • Demographics
  • RAS
  • After defining the options, Teradata Set can be used to estimate how long the export will take given the options selected. See “Estimate Export Time” on page 92.