15.10 - Miscellaneous Housekeeping Columns - 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
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
NodeType n/a Type of node, representing the per node system family type. CHAR(8)
VprId n/a Identifies the vproc number (non-Summary Mode) or the vproc type (Summary Mode; 0 = NODE, 1 = AMP, 2 = PE, 3=GTW, 4=RSG, 5=TVS). INTEGER
VprType n/a The values can be NODE, AMP, PE, GTW, RSG, or TVS (see Teradata Virtual Storage). CHAR(4)
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
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
SummaryFlag n/a Summarization status of this row. Possible values are 'N' if the row is a non-summary row, and 'S' if the row is a summary row. CHAR (1)
NCPUs n/a Number of 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.

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.

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

BIGINT
PM_CPU_COD n/a Platform Metering CPU 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
WM_CPU_COD n/a Workload Management CPU 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.

WM CPU COD is not supported on SLES 10. Its value is set to 1000 on SLES 10.
SMALLINT