Book Image

Teradata Cookbook

By : Abhinav Khandelwal, Viswanath Kasi, Rajsekhar Bhamidipati
Book Image

Teradata Cookbook

By: Abhinav Khandelwal, Viswanath Kasi, Rajsekhar Bhamidipati

Overview of this book

Teradata is an enterprise software company that develops and sells its eponymous relational database management system (RDBMS), which is considered to be a leading data warehousing solutions and provides data management solutions for analytics. This book will help you get all the practical information you need for the creation and implementation of your data warehousing solution using Teradata. The book begins with recipes on quickly setting up a development environment so you can work with different types of data structuring and manipulation function. You will tackle all problems related to efficient querying, stored procedure searching, and navigation techniques. Additionally, you’ll master various administrative tasks such as user and security management, workload management, high availability, performance tuning, and monitoring. This book is designed to take you through the best practices of performing the real daily tasks of a Teradata DBA, and will help you tackle any problem you might encounter in the process.
Table of Contents (19 chapters)
Title Page
Dedication
Packt Upsell
Contributors
Preface
Index

Changing and managing filters


Teradata workload designer portlet on viewpoint helps you to manage and create workloads. As we know, a workload on a system has many parameters attached to it. Any query, before hitting the system, needs to be classified under a particular workload. Once classified, this query goes through a filter check. Imagine this filter as a security guard for a building; he keeps a note of everyone going into a building. And if he has a list of people who are not allowed to enter a building, he will disallow them and stop them from entering the building.

Workload throttle works in the same fashion. Filters stop or give warnings, based on bad queries hitting the system. You can define rules like:

  • Block high estimated runtime queries
  • Block queries on selected objects
  • Block queries with certain join times
  • Block queries with high row estimations
  • Block queries from specific users or IPs

It is recommended to create a filter in warning mode first before aborting queries, so that you...