17.05 - ResHostByLink Macros Output - 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 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(,,,);