Checking Query Status - Analytics Database - Teradata Workload Management

Teradata Vantage™ - Workload Management User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Workload Management
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
aji1628112479055.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1197
Product Category
Teradata Vantage
  • Use the Query Monitor portlet.
    See Teradata® Viewpoint User Guide, B035-2206.
  • Check the status of queries on a given node using the tdwmdmp command at the command prompt.
    Sample output:
    Delayed Requests:
    
    ** WLC of 0 means the actual workload is not throttled **
    
    HOST   SESSION     INT REQ  TYP  DEP  USER NAME	    WLC  RULE TYPE (ID)	NAME	          DELAYD  SWGU  OV BL  PRIO   FLEXQLFY
    /QUERYID
    ____  _________  _________  ___  ___  ____________  ___  ________________________________  _____  ____  __ __  ____   ________
       1	 488612          4	QRY	   1  NBTCP           0	 QRY (	80)Tblop Names	              13	1000   1  0     0
    307191689474943282
       1     488611          4	QRY	   1  NBTCP           0	 QRY (	80)Tblop Names	              13	1000   1  0     0
    307181689474968210
       1     488613          4	QRY	   1  NBTCP           0	 QRY (	80)Tblop Names	              13	1000   1  0     0
    307181689474968214
       1     488615          4	QRY	   1  NBTCP           0	 QRY (	80)Tblop Names	              13	1000   1  0     0
    307181689474968216
       1     488610          4	QRY	   1  NBTCP           0	 QRY (	80)Tblop Names	              13	1000   1  0     0
    307191689474943283
       1     488608          4	QRY	   1  NBTCP           0	 QRY (	80)Tblop Names	              13	1000   1  0     0
    307191689474943284
       1     488609          4	QRY	   1  NBTCP           0	 QRY (	80)Tblop Names	              13	1000   1  0     0
    307181689474968215
       1     488614          4	QRY	   1  NBTCP           0	 QRY (	80)Tblop Names	              13	1000   1  0     0
    307191689474943285
       1     488607          4	QRY	   1  NBTCP           0	 QRY (	80)Tblop Names	              13	1000   1  0     0
    307191689474943287
       1     488616          4	QRY	   1  NBTCP           0	 QRY (	80)Tblop Names	              13	1000   1  0     0
    307191689474943286
    
    Active Requests:
    HOST   SESSION     INT REQ  TYP  DEP  USER NAME	    WLC  RULE TYPE (ID)	NAME	          DELAYD  SWGU  OV BL  PRIO   FLEXQLFY
    /QUERYID
    	
    Rules matching Delayed Requests but below threshold (Non-impacting):