Set Up a Query Capture Database - Teradata Index Wizard

Teradata Index Wizard User Guide

Product
Teradata Index Wizard
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2506
Product Category
Teradata Tools and Utilities

Before you can create and analyze a workload using Teradata Index Wizard, you must first set up 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 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.

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.