Current Logging Characteristic Columns | ResUsageSpdsk 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.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
fwg1557098454552.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢

These columns provide statistics on current logging characteristics.

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
ArrayName n/a

PDISK storage array name.

In Summary mode, the value is set to '---'.

CHAR(32)
PdiskGlobalId n/a Identifies the pdisk in the system. Each pdisk in the system has a global ID which uniquely identifies the pdisk in the system. If a pdisk is connected to the nodes in a clique, all the nodes in that clique see the same pdisk global ID associated with that pdisk.

In Summary Mode, the pdisk global ID is -1.

INTEGER
PdiskType n/a Type of pdisk. The pdisk can be one of the following:
  • DISK: A storage device.
  • FILE: A file.
  • SSD: A solid state device.
  • RSSD: A read intensive solid state device.
  • WSSD: A write intensive solid state device.
  • NETW: A network device.
CHAR(4)
PdiskDeviceId n/a Identifies the local pdisk device.
  • For both DISK and SSD pdisks, the pdisk device ID can be a major/minor number. The major number bit positions are 20-31 and the minor number is in bits 0-19. The format is similar to the one shown below.

    (MMMM MMMM MMMM mmmm mmmm mmmm mmmm mmmm)

  • For FILE pdisk, the pdisk device ID is 0xFFFFFFFF.

In Summary Mode, the pdisk device ID is 0xFFFFFFFF.

BYTE(4)
NodeType n/a Type of node, representing the per node system family type. CHAR(8)
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 field 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. If the value is 'N,' the row is a non-summary row. If the value is 'S,' the row is a summary row. CHAR(1)
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_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. For example, a value of 50 represents a PM I/O COD value of 50.0%.

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