How Many Nodes/AMPs in the system

Database
Enthusiast

How Many Nodes/AMPs in the system

Hi,

Is there any table/view in DBC through which I can query how many nodes in the Teradata system and how many AMPs in each node, so something like that. And also, identify how many of them are TPA and how many are non-TPA nodes.
1 REPLY
Enthusiast

Re: How Many Nodes/AMPs in the system

Hi Pawan,

Any of the below queires can tell u about the no. of Amps in the system :

select count(distinct vproc) from dbc.diskspace
select hashamp()+1
Select Count( distinct vproc) from dbc.AmpUsage

No. of Nodes :
Select count(distinct nodeid) from dbc.resusagescpu;

I am not sure abt the TPA and non - TPA part.