MAPS Manager Best Practices - Teradata Workload Management - 16.20

Teradata® Viewpoint User Guide

Teradata Viewpoint
Teradata Workload Management
User Guide
Method Description
System Monitoring
  • Set up System Monitoring to periodically evaluate map usage.
  • Use after changing the system default map. Set up the analysis to run again.
  • Make sure the user credentials have access to all objects and maps in the system.
  • Set up DBQL settings.
  • Schedule moves during system off-peak hours.
Object Workflows
  • Use Object Workflows after system expansion to redistribute objects over new AMPs.
  • Make sure database user credentials have access to maps and objects needed.
  • Use to move objects from an obsolete sparse map before deleting the map.
  • Set up an exclusion list.
  • Set up DBQL settings.
  • Add a notification set.
  • Evaluate the actionlist.
  • Check Perm space.