Changing the RAS Export 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
  1. From an export dialog box, click Options. The Export Options dialog box appears.
  2. [Optional] In the RAS tag box, type a new file name.

    By default, the RAS tag box displays the file name entered when choosing an export method in the Export from Teradata Database dialog box.



    No more than 128 tables can be selected in the current session. However, an unlimited number of rows can be exported from SystemFE.Opt_RAS_Table.
  3. Click Select Tables.

    The Export Random AMP Samples (RAS) dialog box appears.



  4. Under Select Table Names, do one of the following:
    • Select the tables to export.
    • Click Select All.
  5. To define the way that RAS are exported, select an option.
    Option Description
    Capture from Source Export RAS from SystemFE.Opt_RAS_Table and allow the use of RAS already added to SystemFE.Opt_RAS_Table. These samples can be added manually to SystemFE.Opt_RAS_Table using another tool, such as using the DIAGNOSTIC DUMP statement in Basic Teradata Query (BTEQ).
    Capture from AMPs Export samples from the target system. Use this option to export samples for the selected row directly from the AMPs. This option exports samples to SystemFE.Opt_RAS_Table using the RAS tag specified in the RAS tag box. The samples are deleted after the row is exported.
    If the row exists in SystemFE.Opt_RAS_Table, the Duplicate Random AMP Samples (RAS) dialog opens, enabling the user to select the required option. See Export Options for RAS Duplicate Keys.
    Set Samples Set the RAS for the selected row before exporting. This ensures that the Optimizer uses this set of samples when generating an execution plan. Only one RAS can be set for each table selected.
    This option is available only when exporting by query.
  6. Click OK to close the Export Random AMP Samples (RAS) dialog box and return to the Export Options dialog box.
  7. Click OK to close the Export Options dialog box.