Check Number of VPROC, AMP and PE in Teradata

Select Distinct

NodeID

,NodeType

,VProcType1 || ': ' || TRIM(VProc1) AS AMPs

,VProcType2 || ': ' || TRIM(VProc2) AS PEs

,VProcType3 || ': ' || VProc3 AS GTW

,VProcType4 || ': ' || VProc4 AS RSG

,VProcType5 || ': ' || VProc5 AS TVS

,VProcType6 || ': ' || VProc6 AS VProc6

,VProcType7 || ': ' || VProc7 AS VProc7

From DBC.ResUsageSpma

Order By NodeID;

If ResUSage is not enable then following query can be use:

-- Check number of AMPs and PEs

select count(t1.ProcId) Nodes, sum(t1.AmpCount) Amps, sum(t1.PECount) PEs

from table (MonitorPhysicalResource()) as t1

where t1.Status = 'U';

Nodes

2

Amps

80

Pes

8