Checking Query Status - Advanced SQL Engine - Teradata Workload Management

Teradata Vantage™ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
nbl1556236178169.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1197
lifecycle
previous
Product Category
Software
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):