Use Automated Data Clean-up | Teradata Viewpoint - Using Automated Data Clean-up - Teradata Viewpoint

Teradata® Viewpoint Installation, Configuration, and Upgrade Guide for Customers - 22.10

Product
Teradata Viewpoint
Release Number
22.10
Published
October 2022
Language
English (United States)
Last Update
2022-10-20
dita:mapPath
cez1661858051910.ditamap
dita:ditavalPath
acl1501004736403.ditaval
dita:id
B035-2207
lifecycle
previous
Product Category
Analytical Ecosystem

Run /opt/teradata/viewpoint/dcs/bin/automatedDataCleanup.sh to start clean-up process.

Following options are available from the script:
  1. View older tables
  2. Cleanup older tables
  3. Delete db-backup
  4. Delete /data/archive
  5. Cleanup disabled systems
  6. Run Full Vacuum
  7. Schedule Full Vacuum
  8. Cleanup temporary files
  9. Schedule Cleanup Now
Enter option (or 'q' to quit)
  1. View older tables
    This operation does the following:
    1. Displays the current sum of size of all tables .
    2. Ask the user to provide a year to view tables older than the given year (Defaults to current year).
    3. Ask the user to provide a month for the entered year to view tables older than the given year-month (Defaults to current month).
    4. Displays the sum of the size of all tables older than the provided year.
    5. Outputs the list of tables to a file /tmp/listOfOldTables.yyyy.mm.dd-hh.mm.ss.txt.
  2. Cleanup older tables
    This operation does the following:
    1. Ask the user to provide the filename generated as part of “view older tables” operation.
    2. Deletes the tables in the file.
    3. Outputs each deleted table to new log file →/var/opt/teradata/viewpoint/portal/logs/automatedDataCleanup.log.
    4. Displays the current sum of size of all tables.
  3. Delete db-backup
    This operation does the following:
    1. Ask the user for confirmation to delete.
    2. Deletes the directory /data/db-backup.
  4. Delete /data/archive
    This operation does the following:
    1. Checks if the system is in clustered state.
    2. If yes, exits with error.
    3. If not, asks confirmation to delete the directory.
    4. Deletes the directory.
  5. Cleanup disabled systems
    1. Show the list of disabled systems.
    2. Prompts user to select one or more systems or select all.
    3. Deletes the system and corresponding alert rules.
  6. Run Full Vacuum
    This operation does the following:
    1. Check if full vacuum is enabled on portal.
    2. If not, provide an informational message and then ask user to confirm if full vacuum is to be run now.
    3. If yes, display the last time it was run successfully, the next scheduled time and then ask user to confirm if full vacuum is to be run now.
    4. If yes, run full vacuum.
  7. Schedule Full Vacuum
    1. Check if full vacuum is enabled on portal.
    2. If not, provide an informational message and ask confirmation to proceed.
    3. If yes, display the last time it was run successfully, the current schedule and then ask user for confirmation to proceed.
    4. Prompt the user for Day, Month, Hour and Minute for scheduling the full vacuum.
    5. Schedules the full vacuum job.
  8. Cleanup temporary files
    This operation deletes any temporary files created as part of the script.
  9. Schedule Cleanup Now
    This operation runs cleanup for collector once.