17.05 - Usage Notes - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K

The ResHostByLink macros help you answer the following questions:

  • Is my set up correct?
  • Am I making good use of the channels? If not, how high are they? If not high, then there may not be enough host resources.

Study the incoming traffic. Problems with incoming traffic may be simply caused by an incorrect configuration. Once configured correctly, if there is still a traffic problem, consider studying the TCP/IP network traffic, for example, when doing an export, the ResUsageSpma table may show 30 million rows/log period.

There must be ResUsageShst table rows logged for the period of time that the macro is going to produce a report for.