Columns Showing vprocs Running on a Node | ResUsageSpma Table | Teradata Vantage - Miscellaneous Housekeeping Columns - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
dep1592878989156.ditamap
dita:ditavalPath
dep1592878989156.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢

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 Saving 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)
TheTimestamp n/a Number of seconds since midnight, January 1, 1970.

This column is useful for aligning data with the DBQL log.

BIGINT
CentiSecs n/a Actual 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
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:
  • The first interval after a log rate change
  • A sample logged late because of load on the system
  • System clock adjustments affect reported Secs

Useful for normalizing the count statistics contained in this row, for example, to a per-second measurement.

SMALLINT
NominalSecs n/a Specified or nominal number of seconds in the logging period. SMALLINT
PM_COD_CPU n/a Platform Metering (PM) CPU Capacity On Demand (COD) value in one tenths of percent. For example, a value of 500 represents a PM CPU COD value of 50%.

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
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:
  • Coexistence systems where the number of CPUs can vary across system nodes.
  • Elastic TCore systems where the number of online CPUs can change without database restart.
SMALLINT
Vproc1 n/a Current count of type 1 (AMP) virtual processors running on 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. When the vproc is present on the node, the value is AMP. CHAR(4)
VprocType2 n/a Type of virtual processor for Vproc2. When the vproc is present on the node, the value is PE. CHAR(4)
VprocType3 n/a Type of virtual processor for Vproc3. When the vproc is present on the node, the value is GTW. CHAR(4)
VprocType4 n/a Type of virtual processor for Vproc4. When the vproc is present on the node, the value is RSG. CHAR(4)
VprocType5 n/a Type of virtual processor for Vproc5. When the vproc is present on the node, the value is TVS. CHAR(4)
VprocType6 n/a Type of virtual processor for Vproc6. CHAR(4)
VprocType7 n/a Type of virtual processor for Vproc7. CHAR(4)
MemSize n/a Amount of memory on this node in mega bytes. 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.

INTEGER
Active max Gets set to a non-zero value whenever one of the other data columns in the row is set. FLOAT
NetSamples count Sample count for sampled statistics for a Bynet.
NetSamples is used to normalize all net time monitored statistics to a percent-of-time basis. For example, dividing (NetTxIdle/NetSamples) yields the transmitter-idle time ratio for the net statistics.
FLOAT