The QCF provides a method to capture and store the steps from any query plan in a set of predefined relational tables called the QCD.
Note: A QCD created prior to the latest Teradata Database release must be upgraded for use with the current release. For instructions, see “Upgrading a QCD” on page 97.
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:
a Enter a value.
b Click one of the following: KB, MB, or GB.
7 In the Spool Space box, define the spool space:
a Enter a value.
b 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 an SQL Query” on page 155.
14 Click Close to stop the set up of the QCD and return to the main window.
For more information on the QCF, refer to SQL Request and Transaction Processing B035-1142.
To create the macros and views in a QCD, see “Creating QCF‑Related Views and Macros in a QCD” on page 97.