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;

 

  

NodeID

NodeType

AMPs

PEs

GTW

RSG

TVS

VProc6

VProc7

108

6700

AMP : 40

PE  : 6

GTW :       1

RSG :       1

TVS :       1

    :       0

    :       0

210

6800H08

AMP : 40

PE  : 2

GTW :       1

RSG :       1

TVS :       1

    :       0

    :       0

 

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

Amps

Pes

2

80

8

 




Comments