15.10 - Usage Notes - Teradata Database

Teradata Database Resource Usage Macros and Tables

Product
Teradata Database
Release Number
15.10
Published
April 2016
Language
English (United States)
Last Update
2018-05-17
dita:mapPath
Resource_Usage_Macros_15_10.ditamap
dita:ditavalPath
ft:empty

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.