ResAWT 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 ResAWT, ResAWTByAMP, and ResAWTByNode macros are described in this section.

In the ResAWT output report, the statistics columns, after the Date and Time columns, provide a summary of the AMP Worker Tasks resource usage.

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

Statistics columns Description
1 Node ID.
2 AMP ID.
3 through 24 Summary of AMP Worker Tasks resource usage.

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

Statistics columns Description
1 Node ID.
2 through 23 Summary of AMP Worker Tasks resource usage.

The following table describes the columns in all output reports (with the exception of ResAWTByNode, which has the NodeID column, and ResAWTByAMP, which has the Node ID and AMP ID columns).

Column... Reports the...
Mail box Depth current depth of the AMP work mailbox.
In Flow Ctl AMP that is or is not in flow control.
Flow Ctls Per Sec number of times during the log period that the system entered the flow control state from a non-flow controlled state.
Work New AWTs current number of AMP Worker Tasks in use during the log period for each new first-level secondary work type for the VprId vproc.
Work One AWTs current number of AMP Worker Tasks in use during the log period for each first-level secondary work type for the VprId vproc.
New + One AWTs summary of the previous two columns, Work New AWTs and Work One AWTs.
Work Two AWTs current number of AMP Worker Tasks in use during the log period for each second-level secondary work type for the VprId vproc.
Work 3 AWTs current number of AMP Worker Tasks in use during the log period for each third-level secondary work type for the VprId vproc.
Work Abrt AWTs current number of AMP Worker Tasks in use during the log period for each transaction abort request for the VprId vproc.
Work Spwn AWTs current number of AMP Worker Tasks in use during the log period for each spawned abort request for the VprId vproc.
Work Norm AWTs current number of AMP Worker Tasks in use during the log period for each message that does not fall within the standard work type hierarchy for the VprId vproc.
Work Ctl AWTs
This column is not currently used.
Work Exp AWTs current number of AMP Worker Tasks in use during the log period for each expedited Allocation Groups for the VprId vproc. (Expedited Allocation Groups exist when using the reserved AMP Worker Task pool. For details, see “Priority Scheduler (schmon)” in Teradata Vantage™ - Database Utilities , B035-1102 .)
Max Work New AWTs the maximum number of AMP Worker Tasks in use at one time during the log period for each new work type for the VprId vproc.
Max Work One AWTs the maximum number of AMP Worker Tasks in use at one time during the log period for each first-level secondary work type for the VprId vproc.
Max Work Two AWTs the maximum number of AMP Worker Tasks in use at one time during the log period for each second-level secondary work type for the VprId vproc.
Max Work 3 AWTs the maximum number of AMP Worker Tasks in use at one time during the log period for each third-level secondary work type for the VprId vproc.
Max Work Abrt AWTs the maximum number of AMP Worker Tasks in use at one time during the log period for each transaction abort request for the VprId vproc.
Max Work Spwn AWTs the maximum number of AMP Worker Tasks in use at one time during the log period for each spawned abort request for the VprId vproc.
Max Work Norm AWTs the maximum number of AMP Worker Tasks in use at one time during the log period for each message that does not fall within the standard work type hierarchy for the VprId vproc.
Max Work Ctl AWTs
This column is not currently used.
Max Work Exp AWTs the maximum number of AMP Worker Tasks in use at one time during the log period for each expedited Allocation Groups for the VprId vproc. (Expedited Allocation Groups exist when using the reserved AMP Worker Task pool. For details, see “Priority Scheduler (schmon)” in Teradata Vantage™ - Database Utilities , B035-1102 .)

For a complete description of the columns above, see ResUsageSawt Table Overview.

ResAWT Examples

exec resawt(,,,);

exec resawtByAMP(,,,);

exec resawtByNode(,,,,,);