ResHostByLink Macros Output - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
fwg1557098454552.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢

The reports generated by the ResHostByLink, the ResHostOneNode, and the ResHostByGroup macros, output the following:

Column... Reports the...
Host Type type of host connection:
  • IBMECS
  • IBMMUX
  • IBMNET
  • NETWORK
Host Id Logical ID of host (or client) with sessions logged on.
KBs Read/ Sec number of KB read per second.
KBs Write/ Sec number of KB written per second.
Blks Read/ Sec number of successful blocks read per second.
Blks Write/ Sec number of successful blocks written per second.
Blk Read Fail % percentage of block read attempts that failed.
Blk Write Fail % percentage of block write attempts that failed.
KBs/Blk Read average number of KB per block read.
KBs/Blk Write average number of KB per block written.
Msgs/Blk Read average number of messages per block read.
Msgs/Blk Write average number of messages per block written.
Avg ReqQ Len average number of messages queued for output to the host.
Max ReqQ Len maximum number of messages queued for output to the host.

The NodeID column only appears in the ResHostByLink output report.

The GroupID column only appears in the ResHostByGroup output report.

ResHostByLink Examples

exec resHostByLink(,,,);

exec resHostOneNode(,,,,);

exec resHostByGroup(,,,);