Export Options - System Emulation Tool

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.