find out the number of nodes in a teradata architecture

UDA

find out the number of nodes in a teradata architecture

How can you find out the number of nodes in a particular teradata database architecture? Is there any query that you can fire to find this out?
3 REPLIES
SD
Enthusiast

Re: find out the number of nodes in a teradata architecture

Assuming it is a MPRAS installation, run -

# cat /ntos/mpplist

will show you the list of nodes for the Teradata DBS and also which node is the PDN.
Enthusiast

Re: find out the number of nodes in a teradata architecture

Assuming that all of your nodes were functioning yesterday and you have resusage data being captured (and you have access to resusage data), the following query would tell you the number of nodes:

select count(distinct NodeID)
FROM dbc.ResUsageSPma
where Thedate = date - 1;

Thanks,
Barry
Enthusiast

Re: find out the number of nodes in a teradata architecture

hi i want to know now many hostnodes and hotstandby nodes in my environment is their any query to now from sql assistent

please infrom me