Current Logging Characteristic Columns | ResUsageShst Table | Teradata Vantage - 17.05 - Miscellaneous Housekeeping Columns - Teradata Database

Teradata Vantage™ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K

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
NodeType n/a Type of node, representing the per node system family type. CHAR(8)
VprId n/a Identifies the vproc number.

For channel-connected hosts, the VprId value for:

  • IBMECS is zero.
  • IBMMUX is zero.

For TCP/IP network-connected hosts, the VprId value for:

  • NETWORK is the Gateway vproc ID.
  • IBMNET is zero.

In Summary Mode, VprId is -1.

INTEGER
HstId n/a Identifies the host ID value.
  • For IBMECS, the value is in decimal format RRRRRAAAUUUNNN, where:

    RRRRR = laddr = 5 digit Link address (max value = 65535)

    AAA = cua = 3 digit Channel unit address (max value = 255)

    UUU = lcu = 3 digit Logical control unit address (max value = 255)

    NNN = lchan = 3 digit Logical channel number (max value = 255)

  • For IBMNET, the value is the host group ID.
  • For NETWORK and IBMMUX, the value is BBMMPPHHH, where:

    BB = Bus

    MM = Module Number (or chassis number)

    PP = Port

    HHH = Three digit host group ID

    Each of the fields above get two or three decimal digits of the resulting nine digit value.
    The chassis number is always zero for networks connected hosts.

In Summary Mode, the value is always -1.

BIGINT
HstType n/a Type of host connection:
  • IBMECS (Part TCP/IP and channel hardware connection)
  • IBMMUX (Channel hardware connection)
  • IBMNET (TCP/IP end-to-end, also called “pure network,” connection)
  • NETWORK (Gateway channel connection)
CHAR(8)
IPaddr0, IPaddr1 n/a These columns identify the IP address of the ECS node for the channel-connected IBMECS host. For other hosts, the IP address value is zero.

IPv4 has 4 byte addresses and IPv6 has 16 byte addresses. The first 8 bytes (0 - 7) are stored in IPaddr0, a 64-bit integer field. The second 8 bytes (8 - 16)are stored in IPaddr1, also a 64-bit integer field.

If bytes 4 to 15 are zeros, then the IP address is IPv4.

The ResShstView provides the following aliases for IP addressing.

  • IPv4 - displays IPv4 addresses
  • IPv6 - displays IPv6 addresses
  • IPaddr - displays IP address in either IPv4 or IPv6 format, depending on the type of the address
BIGINT
Secs n/a Actual number of seconds in the log period represented by this row. This value is useful for normalizing the 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. 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
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