Using query band

Teradata Database provides an intelligent way to tag and track your request when they are in Database. When there are several users executing queries on the system using multiple applications, it becomes important to keep track of the requests in Database. By using Viewpoint, you can view the request status, but to track its resource consumption you require another mechanism. Let's understand query band with an example:

Suppose you have an ETLoad job for an application, and you want to track and analyze the execution of jobs so that if something goes wrong with a job, you know when, what, and where it happened. To make it happen you are required to create a log table where all the activity of the job is recorded. Usually, ...

Get Teradata Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.