15.10 - MonitorVirtualConfig - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

Collects information on virtual processor (vproc) availability.

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

The MonitorVirtualConfig function provides similar functionality to the PMPC MONITOR VIRTUAL CONFIG request. For more information, see “MONITOR VIRTUAL CONFIG” on page 165.

 

Column Name

Description

ProcId

ID associated with a node. This value is computed as the module number within a cabinet plus 100 times the cabinet number. Usually formatted for display as zz9-99. However, this display format can be changed by the user.

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.

    Note: This value is NULL for AMP 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.

    SELECT t2.* FROM TABLE (MonitorVirtualConfig()) AS t2;
     
     *** Query completed. 9 rows found. 6 columns returned.
     *** Total elapsed time was 4 seconds.
     
         ProcId      VprocNo  Vproctype  HostId  Status  DiskSlice
    -----------  -----------  ---------  ------  ------  ---------
          134           0       AMP         0       U        -1
          134           1       AMP         0       U        -1
          134           2       AMP         0       U        -1
          134           3       AMP         0       U        -1
          135       10237       TVS         0       U         0
          134       10238       TVS         0       U         0
          135       16380       PE          0       U         0 
          135       16381       PE          0       U         0
          134       16382       PE          0       U         0