15.00 - Export by Workload - System Emulation Tool

Teradata System Emulation Tool User Guide

System Emulation Tool
User Guide

Export by Workload

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.

To export by workload

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 named in step 3 by doing one of the following:

  • In the In folder box, type a path.
  • Click Browse to locate a destination folder using Windows Explorer.
  • By default, the In Folder box displays the path specified in the Options dialog box. See “Directory Options” on page 56.

    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:

  • Specify the workload:
  • i Type the workload name in the Workload box.

    i Type the workload name in the Workload box.

    ii Press Enter.

  • Click the Workload arrow to select a workload from the list.
  • 8 [Optional] To view the statements that make up a workload:

    a Under Workload Information, right‑click the workload name.

    b Click View Workload.

    The View Workload dialog box appears.

    9 [Optional] To move an index recommendation from Workload Information to Selected Workload:

    a Under Workload Information, select a row.

    b Right‑click the row to display the shortcut menu.

    c Click Add.

    10 [Optional] To remove a workload from the export operation:

    a Under Selected Workloads, select a row.

    b Click Remove.

    Note: 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:

    a Right‑click on the heading row.

    b Click Hide/Show Columns.

    c Select headings to hide or show.

    12 [Optional] Under Export Options, select check boxes to define the exported information.

    See “Export Options”on page 79.

    13 [Optional] To further define the selected export options, click Options.

    The Export Options dialog box appears. The options available in this 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” on page 24 and “Estimate Export Time” on page 92.

    15 Click Export to begin the export process.

    After the export operation completes, a summary report of the export operation results appears. See “View a Summary Report” on page 136.

    Note: 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.