Creating a New QCD - Visual Explain

Teradata Visual Explain User Guide
Product
Visual Explain
Release Number
16.20
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-04
dita:mapPath
pvi1488824663157.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2504
Product Category
Teradata Tools and Utilities
  1. Click Tools > Control Center. The Control Center dialog box appears, and the Manage QCD tab is selected.
  2. Click Setup QCD.

    The Setup QCD dialog box appears.



  3. Click Create all QCF Database objects.
  4. In the QCD Name box, enter a name for the QCD.
  5. In the Owner box, enter an owner name. If this box is left blank, the owner defaults to the name of the logged-on user.
  6. In the Perm Space box, define the permanent space:
    1. Enter a value.
    2. Click one of the following: KB, MB, or GB.
  7. In the Spool Space box, define the spool space:
    1. Enter a value.
    2. Click one of the following: KB, MB, or GB.

      The default is 0.

  8. [Optional] Select Fallback to use fallback protection.
  9. Click View Schema to view the schema of the tables and macros created in the new QCD. The View Schema dialog box opens and displays the DDL and macro definitions of the QCD. What is displayed depends on the version of QCF that is running.
  10. Click Modify Perm to modify the permanent space of the existing QCD.
  11. Click Create to set up the QCD.
  12. Click Clear to clear all boxes to their default options.
  13. Click Command to open the Execute SQL window.

    For more information, see Executing a SQL Query.

  14. Click Close to stop the set up of the QCD and return to the main window.