MonitorVirtualConfig Function | Application Programming Reference | Vantage - 17.10 - MonitorVirtualConfig - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1090-171K
Language
English (United States)

Collects information on virtual processor (vproc) availability.

Syntax

REPLACE FUNCTION SYSLIB.MonitorVirtualConfig (
) RETURNS TABLE (
    ProcId INTEGER,
    VprocNo SMALLINT,
    Vproctype VARCHAR(3) CHARACTER SET LATIN,
    HostId SMALLINT,
    Status CHAR CHARACTER SET LATIN,
    DiskSlice SMALLINT
  )
  ...
;

Syntax Elements

ProcId
ID associated with a node.
This value is computed as the module number within a cabinet plus the cabinet number times 10000. For example, a node #123 on cabinet #4 would return an INTEGER value of 40123.
VprocNo
ID of an AMP (that is, a set of disks and the associated tasks or processes that, in combination, make up the AMP), PE, or TVS vproc.
Vproctype
Type of vproc:
  • AMP
  • PE
  • MISC
HostId
Logical host ID associated with a PE or session. For a PE, HostId identifies one of the hosts or LANs associated with the described PE. For a session, the combination of a host ID and a session number uniquely identifies a user session on the system.
This value is NULL for AMPs and TVS vprocs. A value of zero represents the Supervisor window.
Status
Status of the vproc associated with this record. A vproc is considered up or down from the standpoint of whether the vproc is helping a query process SQL statements. For example, an AMP doing offline recovery is considered to be down because the AMP is not helping to process SQL statements. On the other hand, an up vproc is one that is online and fully up or is in online recovery.
The status of the vproc:
  • U = The vproc is up/online.
  • D = The vproc is down/offline.
DiskSlice
Virtual disk ID defining the portion of a physical disk assigned to an AMP.
This value is NULL for TVS vprocs.

Usage Notes

The MonitorVirtualConfig function provides similar functionality to the PMPC MONITOR VIRTUAL CONFIG request. For more information, see MONITOR VIRTUAL CONFIG.

Example: Using MonitorVirtualConfig

SELECT t2.* FROM TABLE (MonitorVirtualConfig()) AS t2;

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

ProcId  VprocNo  Vproctype  HostId  Status  DiskSlice
------  -------  ---------  ------  ------  ---------
 10001        0  AMP             0  U               0
 10001        1  AMP             0  U               1
 10001        2  AMP             0  U               2
 10001        3  AMP             0  U               3
 10001    28670  TVS             0  U               0
 10001    28671  TVS             0  U               0
 10001    30718  PE              1  U               0
 10001    30719  PE              1  U               0