Setting Up a Query Capture Database
To capture and visualize new query execution plans using Teradata Visual Explain, a QCD must be set up.
To set up a new QCD
If a QCD was created for an earlier Teradata Database release, the QCD must be upgraded before being used with the current release. For instructions, see “Upgrade or Revert QCD Version” on page 62. To set up a new QCD, perform this procedure.
1 From the menu bar, 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.
Figure 7: Setup New QCD
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 the box is left blank, the owner defaults to the name of the logged‑on user.
6 The Perm Space box specifies the amount of permanent space for a QCD.
a Enter a value greater than or equal to the default value. The default value is an estimate of space for a QCD.
b Click one of the following units of space: KB, MB, or GB.
7 In the Spool Space box:
a Enter a value.
b Click KB, MB, or GB.
The default is 0 MB.
8 [Optional] Select the Fallback check box to use fallback protection.
9 [Optional] Click View Schema to view the schema of the tables and macros created in the new QCD.
The View Schema dialog box appears and displays the DDL and macro definitions of the QCD. What is displayed depends on the version of QCF that is running.
10 [Optional] Click Clear to clear all boxes and restore the default options.
11 [Optional] Click Command to open the Execute SQL window.
For more information, see “Executing an SQL Query” on page 159.
12 Click Create to set up the QCD.
Note: Click Close to stop the set up of the QCD (before set up is complete) and return to the main window.
To modify the permanent space of a QCD
Use this procedure to modify the permanent space of a QCD.
1 Perform steps step 1 through step 3 of the procedure “To set up a new QCD” on page 61.
2 In the QCD Name box, enter the name of the QCD to be modified.
3 In the Perm Space box:
a Enter a value.
b Click KB, MB, or GB.
4 Click Modify Perm to modify the perm space of the existing QCD.