Example Script to find the Nodes, AMP and PE's in a system in Teradata - Diagram and Representation

----- How to find the total nos. of AMP and PE per node

SELECT DISTINCT NODEID,VPROC1 AS "NO_OF_AMPS" , VPROC2 AS "NO_OF_PE"FROM DBC.ResGeneralInfoView;

---- The result will be as follows:

For NODE 101, we have 2 AMPs and 1 PE. Many Developers make the mistake that each vproc is 1 AMP and 1 PE.

Each PE can spun upto 120 sessions. Though, this configuration is tunable, but its best left unchanged.

We should just add enough PE's to handle session load.

Most people feel that the PE will be equal to the no. of AMP's in the system.

That is not the case as illustrated in the diagram below.

Node Configuration in Teradata

vproc comprises of AMP and PE. PE can also talk to other nodes. Hence for representational purpose, we show the PE above the AMP's as show below:

PE and AMP diagram

Join us in a discussion on Teradata in our classroom. Register using the link and we will contact you.