Cleaning Up a QCD - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2504
lifecycle
previous
Product Category
Teradata Tools and Utilities

Cleaning Up a QCD

Clean up a QCD to get rid of unwanted execution plans or database objects residing in the QCD.

To clean up a QCD

Connect to Teradata Database before cleaning up a QCD.

1 Click Tools>Control Center.

The Control Center dialog box appears, and the Manage QCD tab is selected.

2 Click Cleanup QCD.

The Cleanup QCD dialog box appears.

3 In the QCD Name box, do one of the following:

  • Select a QCD to clean up.
  • Click for a list of QCDs that are available on the server.
  • 4 From the Cleanup QCD dialog box, click one of the following:

  • Execution Plans
  • Database Objects
  • Workloads
  • Entire Database
  • Demographics
  • 5 Go to the procedure that corresponds, respectively, to the option selected in step 4:

  • “Deleting Execution Plans from a QCD” on page 102 (execution plans)
  • “Deleting QCD-related Database Objects” on page 103 (database objects)
  • “Deleting Workloads” on page 103 (workloads)
  • “Deleting the QCD” on page 106 (entire database)
  • “Deleting Demographics” on page 106 (demographics)