TDWMAssignWD Syntax - Teradata VantageCloud Lake

Lake - Monitor Resources and Performance

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
wyu1683671641248.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
wyu1683671641248
REPLACE FUNCTION TDWM.TDWMAssignWD (
  HostId SMALLINT,
  SessionNo INTEGER,
  VprocNo INTEGER,
  Scope VARCHAR(1),
  WDId INTEGER
) RETURNS INTEGER
  ...
;

Syntax Elements

HostId
ID of the host on which the session was issued. HostId cannot exceed 1023. A hostid of zero identifies the database operator Console.
SessionNo
Session number. SessionNo combined with HostId produces a unique session ID.
VprocNo
PE Vproc number where the session runs.
Scope
Scope of the change defined:
  • R = Change the workload of the current request
  • S = Change the workload of the session
WDId
WD ID to which the request must be assigned.