MonitorSQLSteps 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 SYSLIB.MonitorSQLSteps (
  HostIdIn SMALLINT,
  SessionNoIn INTEGER,
  RunVprocNo SMALLINT
) RETURNS TABLE (
    HostId SMALLINT,
    SessionNo INTEGER,
    DynamicPlan SMALLINT,
    PartialSteps SMALLINT 
    StepNum INTEGER,
    Confidence SMALLINT,
    EstRowCount FLOAT,
    ActRowCount FLOAT,
    EstRowCountSkew FLOAT,
    ActRowCountSkew FLOAT,
    EstRowCountSkewMatch FLOAT,
    ActRowCountSkewMatch FLOAT,
    EstElapsedTime FLOAT,
    ActElapsedTime FLOAT,
    SQLStep  VARCHAR(2048)CHARACTER SET UNICODE
  )
  ...
;