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.
- 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.
- 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.
- DiskSlice
- Virtual disk ID defining the portion of a physical disk assigned to an AMP.
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