Cleaning Up a QCD - Visual Explain

Teradata Visual Explain User Guide

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

Clean up a QCD to get rid of unwanted execution plans or database objects residing in the 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 100 (execution plans)
  • “Deleting QCD-related Database Objects” on page 101 (database objects)
  • “Deleting Workloads” on page 101 (workloads)
  • “Deleting the QCD” on page 104 (entire database)
  • “Deleting Demographics” on page 104 (demographics)