Current Logging Characteristic Columns | ResUsageSps Table | Teradata Vantage - Miscellaneous Housekeeping Columns - Advanced SQL Engine - Teradata Database

The default PGs (System, L, M, H, R) have no associated WD and will have a WDID of zero in the table. Only PGs with a name that has “TDWMWD” (SLES 11 or higher) in it have a nonzero WDID.

Resource usages of the workload definition (WD) to which a job instance was assigned can be obtained by joining the DBC.DBQLUtilityTbl table and DBC.ResSPSView on the WDID column for the duration of the job instance.

The example below calculates the sums of IOTA (I/O token allocation) columns.

SELECT SUM(FullPotentialIota), SUM(CodPotentialIota), SUM(UsedIota)
FROM DBC.ResSpsView S,
     DBC.DBQLUtilityTbl U
WHERE S.WDID = U.WDID
  AND U.UtilityName = 'MULTLOAD'
  AND U.UserName = 'USER1'
  AND U.JobEndTime = TIMESTAMP '2013-04-19 16:48:14.98'
  AND S.TheDate >= CAST(Phase1StartTime AS DATE)
  AND S.TheTime >= ((EXTRACT(HOUR FROM Phase1StartTime) * 10000) +
                    (EXTRACT(MINUTE FROM Phase1StartTime) * 100) +
                    (EXTRACT(SECOND FROM Phase1StartTime)))
  AND S.TheDate <= CAST(Phase2EndTime AS DATE)
  AND S.TheTime <= ((EXTRACT(HOUR FROM Phase2EndTime) * 10000) +
                    (EXTRACT(MINUTE FROM Phase2EndTime) * 100) +
                    (EXTRACT(SECOND FROM Phase2EndTime)));

• 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.

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.

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.

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

The value is set to 1000 if the PM CPU COD is disabled.

The value is set to 100 if the PM I/O COD is disabled.

The value is set to 1000 if the WM CPU COD is disabled.

The value is set to 100 if the WM I/O COD is disabled.

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.