ResNode 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 ResNode, the ResOneNode, the ResNodebyNode, and the ResNodeByGroup macros, output the following.

The following table describes the statistics columns, after the Date and Time columns, in the ResNode output report.

Statistics columns Description
1 through 3 CPU usage.
4 through 8 Logical device interface.
9 through 14 Memory interface.
15 through 17 Net interface.
18 and 19 General node process scheduling.

The following table describes the statistics columns, after the Date and Time columns, in the ResOneNode output report.

Statistics columns Description
1 and 2 CPU usage.
3 through 6 Logical device interface.
7 through 11 Memory interface.
12 through 14 Net interface.
15 and 16 General node process scheduling.

The following table describes the statistics columns, after the Date and Time columns, in the ResNodebyNode output report.

Statistics columns Description
1 and 2 CPU usage.
3 through 6 Logical device interface.
7 through 12 Memory interface.
13 through 15 Net interface.
16 and 17 General node process scheduling.

The following table describes the statistics columns, after the Date and Time columns, in the ResNodeByGroup output report.

Statistics columns Description
1 GroupId as defined in the associated view as a grouping of one or more nodes.
2 and 3 CPU usage.
4 through 7 Logical device interface.
8 through 12 Memory interface.
13 through 15 Net interface.
16 and 17 General node process scheduling.

The following table describes the statistics columns in all output reports (with the exception of ResNodeByNode, which has a NodeID column, and ResNodeByGroup, which has a GroupId column).

Column… Reports the…
CPU Bsy % percent of time the CPUs are busy, based on average CPU usage per node.
CPU Eff % (ResNode report) parallel efficiency of node CPU usage.

Parallel efficiency is the total percent of time nodes are busy. It is the average for all nodes of total busy divided by the total busy time of the busiest node.

WIO % percent of time the CPUs are idle and waiting for completion of an I/O operation.
Ldv IO KBs /Sec average number of logical device read and write KB per second.
Ldv Eff % (ResNode report) parallel efficiency of the logical device (disk) I/Os. It is the average number of I/Os per node divided by the number of I/Os performed by the node with the most I/Os.
P+S % of IO KBs percent of logical device read and write KB that are for paging purposes.
Read % of IO KBs percent of logical device read and write KB that are reads.
Ldv KB / IO average size of a non-swap/page logical device read or write.
Fre Mem % percent of memory that is unused.
TPtP IOs /Sec total point-to-point net reads and writes per second, per node.
TMlt IOs /Sec total multicast (broadcast or merge) net reads and writes per second, per node.
Net Rtry % percent of transmission attempts that resulted in retries.
Prc Blks / Sec number of times per second, per node, that processes other than message and timer waits are blocked.
ms /Blk average time, in milliseconds, spent waiting for a blocked process other than message and timer waits.
Net Rx % Bsy percent of time the network was busy either receiving.
Net Tx % Bsy % percent of time the network was busy transmitting.

ResNode Examples

exec resNode(,,,);

exec resOneNode(,,,,);

exec resNodeByNode(,,,,,);

exec resNodeByGroup(,,,);