Changing Import Options - System Emulation Tool

Teradata System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-12
dita:mapPath
gnf1527114222337.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities
The characteristics of an import can be changed prior to importing information to a test system.
  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.
    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.

    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.

    QCD Selection
    Target QCD Specify the QCD listed as the destination QCD for the import operation.
    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.
    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.
    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.
    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.
    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.
    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.
    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.
    Maps Imports MAP information into SystemFE.Opt_Map_Table and SystemFE.Opt_MapRel_Table
    Miscellaneous Options
    Only synchronize version of created tables Only synchronize the version with the tables successfully created by Teradata SET during the import operation.
    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.
    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] See Error-Handling Options.
  6. Click OK to close the dialog box and return to the Import window.
    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.
  7. [Optional] See Saving Changed Information.
  8. [Optional] Click to start the import operation. See Importing to a Test System.