16.20 - TDWMActiveWDs - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Application Programming Reference

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1090-162K

Purpose

Returns a list of all active workloads. TDWMActiveWDs is a table function.

Definition

REPLACE FUNCTION TDWMActiveWDs ()
  RETURNS TABLE
   (WDId INTEGER,
    WDName VARCHAR(30) CHARACTER SET UNICODE,
    Status VARCHAR(8) CHARACTER SET LATIN,
    SLG INTEGER,
    PGID INTEGER,
    AGID INTEGER,
    LogMode VARCHAR(8) CHARACTER SET LATIN,
    CurrOpEnv INTEGER,
    ActualOpEnv INTEGER
   )
LANGUAGE C
NO SQL
NO EXTERNAL DATA
PARAMETER STYLE SQL 
NOT DETERMINISTIC 
CALLED ON NULL INPUT 
EXTERNAL NAME 'SL!api'';

Usage Notes

The GDO for TDWM.TDWMActiveWDS exceeds the size of the protected buffer, so this function uses the non-protected buffer. Note, this means the function is not protected.

Result Rows

Column Name Data Type Description
WDId INTEGER The WD number
WDName VARCHAR The WD name
Status VARCHAR Enabled status
SLG INTEGER Service level goal
PGID INTEGER Performance group number assigned to the WD
AGID INTEGER Allocation group number assigned to the WD
LogMode VARCHAR Type of logging
CurrOpEnv INTEGER Current operating environment
ActualOpEnv INTEGER Active operating environment

Example: Using TDWMActiveWDs

sel * from table (TDWMActiveWDs()) as t1;

*** Query completed. One row found. 9 columns returned. 
 *** Total elapsed time was 1 second.

 WDId  WDName       Status   SLG  PGID   AGID  LogMode    CurrOpEnv  ActualOpEnv
-----  ----------  -------  ----  ----  -----  --------  ----------  -----------
  250  WD-Default  Default     0     0      0  Summary           12           12