15.10 - ResPs Macros Output - Teradata Database

Teradata Database Resource Usage Macros and Tables

Product
Teradata Database
Release Number
15.10
Published
April 2016
Language
English (United States)
Last Update
2018-05-17
dita:mapPath
Resource_Usage_Macros_15_10.ditamap
dita:ditavalPath
ft:empty

The reports in the following sections are sample output reports from the ResPsByNode and ResPsByGroup macros.

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

Statistics columns Description
1 Node ID.
2
  • On SLES 10 or later systems, this column contains the PG ID.
  • On SLES 11 or later systems, this column contains the pWDId.

    In the ResPs macro outputs, the RowIndex1 column displays as PGid, instead of pWDid, when running SLES 11 or later systems. For a description of the RowIndex1 column, see ResUsageSps Miscellaneous Housekeeping Columns.

3 through 12 Summary of the Priority Scheduler statistics.

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

Statistics columns Description
1 Node type.
2 through 11 Summary of the Priority Scheduler statistics.

The following table describes the statistics columns in all output reports (with the exception of ResSpsByNode, which reports by NodeID columns, and ResSpsByGroup, which reports by NodeType column).

Column... Reports the...
CPU Bsy % percent of time the CPUs are busy, based on average CPU usage per node.
IO Blks Sec number of logical data blocks read or written.
Num Procs average number of tasks of online nodes.
Num Requests number of AMP Worker Task messages or requests that got assigned AMP Worker Tasks to them.
Avg QWait Time average time in milliseconds that work requests waited on an input queue before being serviced.
Max QWait Time maximum time in milliseconds that work requests waited on an input queue before being serviced.
Q Length average number of messages queued for output to the host.
Q Len Max maximum number of messages queued for output to the host.
Avg Svc Time average time in milliseconds that work requests required for service
Max Svc Time maximum time in milliseconds that work requests required for service.

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

ResPs Examples

The column label, RowIndex1, displays as PGid, instead of pWDid, when running SLES 11 or later systems. For a description of the RowIndex1 column, see ResUsageSps Table.

exec resPsByNode(,,,,,);

exec resPsByGroup(,,,);