Set Up a Query Capture Database
Before you can create and analyze a workload using Teradata Index Wizard, you must first set up a QCD.
To set up a new QCD
1 Click Tools > Setup QCD.
The Setup QCD dialog box appears.
2 Click Create all QCF Database objects.
3 In the QCD Name field, enter a name for the new QCD.
4 In the Owner field, enter an owner name. The owner name defaults to the name of the current user.
5 In the Perm Space field, enter a value for the permanent space you want to reserve for the QCD and then select a unit of measurement (KB, MB, GB). The default value is 1 MB.
6 In the Spool Space field, enter a value for the spool space you want to reserve for the QCD and then select a unit of measurement (KB, MB, GB). The default value is 0 MB.
7 [Optional] Select Fallback to use fallback protection.
8 [Optional] Click Clear to clear all fields and to restore the default values.
9 [Optional] Click Command to open the Execute SQL window.
10 Click Create to set up the QCD.
To modify the permanent space of a QCD
1 Click Tools > Setup QCD.
The Setup QCD dialog box appears.
2 Click Create all QCF Database objects.
3 In the QCD Name field, enter the name of the QCD you want to modify.
4 In the Perm Space field, enter a new value for the permanent space you want to reserve for the QCD and then select a unit of measurement (KB, MB, GB)
5 Click Modify Perm.