MonitorVirtualResource Example - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
SELECT VprocNo, VprocType, Status, PRocId, ClusterNo FROM
TABLE (MonitorVirtualResource()) AS t2;

 *** Query completed. 8 rows found. 5 columns returned.
 *** Total elapsed time was 1 second.

VprocNo  VprocType  Status  ProcId  ClusterNo
-------  ---------  ------  ------  ---------
      0  AMP        U        10001          0
      1  AMP        U        10001          1
      2  AMP        U        10001          0
      3  AMP        U        10001          1
  28670  TVS        U        10001          0
  28671  TVS        U        10001          0
  30718  PE         U        10001       1025
  30719  PE         U        10001       1025