Exporting by Workload - 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

Use this export method to choose a QCD database and multiple workloads for export and to define the details for the specific emulation information to capture.

  1. From the main window, click . The Export from Teradata Database dialog box appears.
  2. Click Workload.
  3. In the File name box, type a file name for the exported emulation information. By default, the File Name box displays the name of the target system specified when connecting.
  4. Specify a path to the folder in which to save the file. By default, the In Folder box displays the path specified in the Options dialog box. See Directory Options.
  5. Click OK. The Export By Workload dialog box appears.


  6. Select a QCD database to be the source of the workload information by doing one of the following:
    • Type the name of the database in the QCD Database box.
    • Click to select a database from the QCD Database list.
  7. [Optional] To load index recommendations for the selected workload, do one of the following to specify the workload:
    Specify the workload by...
    1. Typing the workload name in the Workload box.
    2. Pressing Enter.
    Specify the workload by... Clicking the Workload arrow to select a workload from the list.
  8. [Optional] To view the statements that make up a workload:
    1. Under Workload Information, right-click the workload name.
    2. Click View Workload. The View Workload dialog box appears.
  9. [Optional] To move an index recommendation from Workload Information to Selected Workload:
    1. Under Workload Information, select a row.
    2. Right-click the row to display the shortcut menu.
    3. Click Add.
  10. [Optional] To remove a workload from the export operation:
    1. Under Selected Workloads, select a row.
    2. Click Remove.
      For a workload without any recommendations, the Index tag and Recommendation Time boxes are empty.
  11. [Optional] To customize the headings under Workload Information or Selected Workload:
    1. Right-click the heading row.
    2. Click Hide/Show Columns.
    3. Select headings to hide or show.
  12. [Optional] Under Export Options, select check boxes to define the exported information. See Export Options.
  13. [Optional] To further define the selected export options, click Options. The Export Options dialog box appears. The options available in the dialog box depend on the selections made under Export Options on the Export By Workload dialog box.
  14. [Optional] Click Estimate Time to see the estimated time required to process the export request. See Estimate-Time Rights and Viewing the Estimated Export Time.
  15. Click Export to begin the export process. After the export operation completes, a summary report of the export operation results appears. See Viewing a Summary Report.
    The Partition Tag column in the workload information and selected workloads displays the partition recommendation tag name. When a partition recommendation tag is displayed, the Index Tag column is blank. When the Index Tag column displays an index tag, the Partition Tag column is blank.