find out the number of nodes in a teradata architecture

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

find out the number of nodes in a teradata...

Rate Topic

Display Mode

Topic Options

Author

Message

Shefali

Posted 2/22/2006 2:45:55 AM

Forum Newbie

Group: Forum Members
Last Login: 4/13/2007 8:06:00 AM
Posts: 3, Visits: 1

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?

Post #3560

Posted 2/28/2006 11:01:30 AM

Junior Member

Group: Forum Members
Last Login: 4/13/2006 9:39:00 AM
Posts: 24, Visits: 1

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.

Post #3625

Barry

Posted 3/1/2006 9:28:09 AM

Supreme Being

Group: Forum Members
Last Login: 6/9/2008 2:55:55 PM
Posts: 185, Visits: 2

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

Post #3636

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 2 ( 2 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 11:38pm