These columns provide a generalized picture of the vprocs running on this node, shown as Type n virtual processors where n = 1 to 7. Under the current implementation, only Type 1 (AMP), Type 2 (PE), Type 3 (GTW), Type 4 (RSG), and Type 5 (TVS) vprocs exist; vproc types 6 through 7 are not currently used.
Column Name | Mode | Description | Data Type |
---|---|---|---|
GmtTime | n/a | Greenwich Mean Time is not affected by the Daylight Savings Time adjustments that occur twice a year. | FLOAT |
CabinetID | n/a | The physical cabinet number of the node. | INTEGER |
ModuleID | n/a | The physical module number of the node. | INTEGER |
NodeType | n/a | Type of node, representing the per node system family type. | CHAR(8) |
NCPUs | n/a | Number of online CPUs on this node. This column is useful for normalizing the CPU utilization column values for the number of CPUs on the node. This is especially important in:
|
SMALLINT |
Vproc1 | n/a | Current count of type 1 (AMP) virtual processors running under the node. | SMALLINT |
Vproc2 | n/a | Current count of type 2 (PE) virtual processors running under the node. | SMALLINT |
Vproc3 | n/a | Current count of type 3 (GTW) virtual processors running under the node. | SMALLINT |
Vproc4 | n/a | Current count of type 4 (RSG) virtual processors running under the node. | SMALLINT |
Vproc5 | n/a | Current count of type 5 (TVS) virtual processors running under the node. | SMALLINT |
Vproc6 | n/a | Current count of type 6 virtual processors running under the node. This column reports zeros. |
SMALLINT |
Vproc7 | n/a | Current count of type 7 virtual processors running under the node. This column reports zeros. |
SMALLINT |
VprocType1 | n/a | Type of virtual processor for Vproc1. Value is always AMP. | CHAR(4) |
VprocType2 | n/a | Type of virtual processor for Vproc2. Value is always PE. | CHAR(4) |
VprocType3 | n/a | Type of virtual processor for Vproc3. Value is always GTW. | CHAR(4) |
VprocType4 | n/a | Type of virtual processor for Vproc4. Value is always RSG. | CHAR(4) |
VprocType5 | n/a | Type of virtual processor for Vproc5. The value is always TVS (see Teradata Vantage™ - Teradata® Virtual Storage , B035-1179 ). | CHAR(4) |
VprocType6 | n/a | The type of virtual processor for Vproc6. | CHAR(4) |
VprocType7 | n/a | The type of virtual processor for Vproc7. | CHAR(4) |
MemSize | n/a | Amount of memory on this node in megabytes. Useful for performing memory usage calculations. | BIGINT |
NodeNormFactor | n/a | A per CPU normalization factor that is used to normalize the reported CPU values of the ResUsageSpma table to a single 5100 CPU. This value is scaled by a factor of 100. For example, if the actual factor is 5.25, the value of the NodeNormFactor will be 525. The normalization factor is related to the NodeType value reported in the ResUsageSpma table. For information on this value, see ResUsageSpma Table Overview.
|
INTEGER |
Secs | n/a | Actual number of seconds in the log period represented by this row. Normally the same as NominalSecs, but can be different in three cases:
Useful for normalizing the count statistics contained in this row, for example, to a per-second measurement. |
SMALLINT |
CentiSecs | n/a | Number of centiseconds in the logging period. This column is useful when performing data calculations with small elapsed times where the difference between centisecond-based data and whole seconds results in a percentage error. | INTEGER |
NominalSecs | n/a | Specified or nominal number of seconds in the logging period. | SMALLINT |
Active | max | Controls whether or not the rows will be logged to the resource usage tables if Active Row Filter Mode is enabled. If Active is set to a non-zero value, the row contains data columns. If Active is set to a zero value, none of the data columns in the row have been updated during the logging period. For example, if you enable Active Row Filter Mode, the rows that have a zero Active column value will not be logged to the resource usage tables. |
FLOAT |
TheTimestamp | n/a | Number of seconds since midnight, January 1, 1970. | BIGINT |
PM_COD_CPU | n/a | Platform Metering (PM) CPU Capacity On Demand (COD) value in one tenths of a percent. For example, a value of 500 represents a PM CPU COD value of 50.0%. The value is set to 1000 if the PM CPU COD is disabled. |
SMALLINT |
PM_COD_IO | n/a | Platform Metering (PM) I/O Capacity On Demand (COD) value in whole percent values for the entire system. For example, a value of 50 represents a PM I/O COD value of 50%. The value is set to 100 if the PM I/O COD is disabled. |
SMALLINT |
WM_COD_CPU | n/a | Workload Management (WM) CPU Capacity On Demand (COD) value in one tenths of a percent. For example, a value of 500 represents a WM CPU COD value of 50.0%. The value is set to 1000 if the WM CPU COD is disabled. |
SMALLINT |
WM_COD_IO | n/a | Workload Management (WM) I/O Capacity On Demand (COD) value in whole percent. For example, a value of 50 represents a WM I/O COD value of 50.0%. The value is set to 100 if the WM I/O COD is disabled. |
SMALLINT |
TIER_FACTOR | n/a | I/O performance limit placed on a core-reduced node. For example, a value of 75 represents an I/O limit of 75.0% placed before other COD values. The field is sourced from tpanodep->tierfactor, which is derived from the /proc/tdmeter/tier_performance file. A value of 100 indicates that there is no I/O performance limit applied to the node. |
SMALLINT |