ResHostByLink Macros Output - Analytics Database - Teradata Vantage

Resource Usage Macros and Tables

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-10-30
dita:mapPath
efj1628112349534.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
wqp1472240716284
lifecycle
latest
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(,,,);