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

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

Product
Teradata Viewpoint
Release Number
17.10
Release Date
October 2021
Content Type
Administration
Configuration
Installation
Publication ID
B035-2207-101K
Language
English (United States)

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
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 given year (Defaults to current year)
    3. Displays the sum of the size of all tables older than the provided year
    4. 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.