Teradata how many nodes

Still the total number of AMPS in the configuration will be fixed. In a clique, usually all the nodes in that clique have the same configuration like lets suppose you have 40 AMPS on a particular node in a clique, the HSN also will have the same 40 AMPs but they will become active only when the HSN is brought into active configuration. For HSN in the configuration this will be displayed as 0.

Register Log in. Search form Search. Welcome to the Teradata Forums. Read the guidelines on posting. Email notifications and RSS feeds are available, and also a chronological list of all forum activity. I am not sure here if am rite, but my understanding is there will be multiple AMP's at each node. Register Log in. Search form Search.

Welcome to the Teradata Forums. Read the guidelines on posting. Email notifications and RSS feeds are available, and also a chronological list of all forum activity. How to find the no of nodes in my teradata system using sql assistant?

I only have access to sql assistant. Is there a way to find using that? Another option I can think of is to query the Resourse usage views and macros. Dear Annal,That helped me in figuring the no of nodes in my system. Thank you. You can find it from DBC. Even though the arrays are attached to the nodes, each amp controls its' own logical unit lun of disk space.

Logical units allow each amp to process the work assigned to it in parallel with the other amps. LUNs aren't shared across amps. Arrays are shared across nodes to enable a hot standby node to seamlessly step in and replace a failed node with minimal performance impact. The number of rows will impact your distribution skew, especially for very small tables on a large system, e.

I Second Blaine on the PI. When a table is created on Teradata platform, all the amps in the system will have the header information of the table which is not accessible to users except internal to Teradata you can say BYNET. When a query is fired, the BYNET looking at the header will be able to identify the data on the amps and will retrieve it from the disks. These AMPS are located on all the nodes which are currently active in the system there are systems where Hot stand By nodes will be present.

HTH: the Bynet doesn't look at the table header, it simply does a lookup in the Hashmap. Each system has a so-called Hashmap which is specifically created during sysinit for that system and determines the AMP on which a row is stored. This Hashmap is is an array of values, each value is the number of an AMP. Register Log in. Search form Search. Welcome to the Teradata Forums.