15.00 - Change Import 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

Change Import Options

The characteristics of an import can be changed prior to importing information to a test system.

To change import options

1 From the Import window, click .

The Import Options dialog box appears.

 

Option

Description

Parent Database Info

Parent Database

Specify a database name to be the owner for any database or user created during the import operation.

Note: This option is available only when importing object definitions, demographics, execution plans, and workloads.

External DBQL Selection

Target DBQL

Specify the DBQL listed as the destination DBQL for the import of XML plans.

Note: This option is only available when importing DBQL XML Plans.

If a target DBQL is not selected, then the DBQL Database from which the plans are exported becomes the target DBQL.

If the target DBQL is DBC, the import is terminated.

If the Target DBQL database specified does not exist, Teradata SET either prompts for the creation of the DBQL, or it automatically creates the DBQL depending on the selected import error handling options. See “Error‑Handling Options” on page 57.

QCD Selection

Target QCD

Specify the QCD listed as the destination QCD for the import operation.

Note: This option is available only when importing execution plans, QCD data, demographics, or workloads. If no target QCD is specified, the information is imported into the QCD from which it was exported. If the database does not exist, Teradata SET either prompts for the creation of the QCD or automatically creates the QCD, depending on the import error handling options. See “Error‑Handling Options” on page 57.

Source Version

Display the QCF version number of the export system.

Current Version

Display the QCF version number of the system to which Teradata SET is connected.

Import Options

Object Definitions

Create or define the database objects.

Random AMP Samples

Import RAS into SystemFE.Opt_RAS_Table.

Execution Plans

Import execution plans into a QCD.

Note: It is possible to import execution plans to a later version of Teradata Database. However, to import execution plans to an earlier version requires that a compatible‑version QCD exist on Teradata Database.

QCD Data

Import index recommendations, workload definitions, and execution plans to the QCD specified in the Target QCD box.

Note: This check box is available only if an export‑by‑database operation was performed for one or more databases marked as QCDs and the QCD Data check box was selected. To import only execution plans, clear the QCD Data check box and select Execution Plans. If the Target QCD box is left blank, the system creates QCDs with the same names as those used during export. Data is then imported into these QCDs. See “Error‑Handling Options” on page 57.

Cost Profiles

Import cost profiles into the Data Dictionary.

Statistics

Import the statistics into the Data Dictionary.

Demographics

Import table demographics to the QCD specified in the Target QCD box.

Note: If the Target QCD box is left blank, the system creates QCDs with the same names as those used during export. Data is then imported into these QCDs.

Workloads

Import the workload definitions and any index recommendations to the QCD specified in the Target QCD box during export.

Note: This check box is available when exporting by workload. If the Target QCD box is left blank, the system creates QCDs with the same names as those used during export. Data is then imported into these QCDs.

Cost Parameters

Import system cost parameters into SystemFE.Opt_Cost_Table and import DBS Control information associated with the cost parameters.

DBQL Plans

Import DBQL XML Execution Plans into a DBQL.

Miscellaneous Options

Only synchronize version of created tables

Only synchronize the version with the tables successfully created by Teradata Set during the import operation.

Note: If the check box is not selected, the QCD.RELATION table is synchronized with the version in the DBC.TVM table for all tables referred to in the execution plan queries. This feature is available only when the Object Definitions and Execution Plans check boxes are selected.

Import original statistics collection timestamp

Use the original timestamp value for all statistics data in the current import operation.

Note: If the check box is not selected, all statistics data in the current import operation is imported using the current timestamp value.

2 [Optional] In the Parent Database box, do one of the following:

  • Type an owner name for any databases or users created during the import operation.
  • Click to load the available databases and select one from the list.
  • By default, the Parent Database box displays the database name established when logging on.

    3 [Optional] In the Target QCD box, specify the destination QCD for the import by doing one of the following:

  • Type a QCD name in the Target QCD box.
  • Click to load the available QCDs and select one from the list.
  • 4 [Optional] Under Import Options, clear check boxes to exclude items from the import.

    This results in a partial import. Options are available only if they were included in the export.

    5 [Optional] Click Error Handling to change how errors are handled during the import operation.

    See “Error‑Handling Options” on page 57.

    6 Click OK to close the dialog box and return to the Import window.

    Note: A appears next to the object in the left pane that corresponds to a selection made under Import Options in the Import Options dialog box (see step 4).

    7 [Optional] Save the import options for a future import operation.

    See “Save Changed Information” on page 111.

    8 [Optional] Click to start the import operation.

    See “Import to a Test System” on page 95.