Creating a New QCD

Teradata Visual Explain User Guide

Teradata Tools and Utilities
Visual Explain
User Guide
  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.