The following provides information for accessing the resource usage views.
To see the view definitions, execute SHOW VIEW viewname, where viewname is the name of the view whose most recent SQL create text is to be reported. For details on using the SHOW VIEW statement, see Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184.
The following views report the table column, GroupId. A homogeneous system requires no changes to use this macro because all the nodes will be assigned to group A. For a coexisting system, however, the values need to be set up when the system is installed or reconfigured so that each type of node is assigned to a specific group ID.
Since each of the views include all the columns for the represented table, the views will be changed whenever the base table columns are changed.
| View | Description |
|---|---|
| ResCPUUsageByAMPView | Describes CPU usage per AMP |
| ResCPUUsageByPEView | Describes CPU usage by each PE |
| ResSawtView | Based on the ResUsageSawt table |
| ResScpuView | Based on the ResUsageScpu table |
| ResShstView | Based on the ResUsageShst table |
| ResSldvView | Based on the ResUsageSldv table |
| ResSmhmView | Based on the ResUsageSmhm table. Reserved for future use. |
| ResSpdskView | Based on the ResUsageSpdsk table |
| ResSpmaView | Based on the ResUsageSpma table |
| ResSpsView | Based on the ResUsageSps table |
| ResSvdskView | Based on the ResUsageSvdsk table |
| ResSvprView | Based on the ResUsageSvpr table. |