How to know AMPs and Nodes list from teradata database from working application

General

How to know AMPs and Nodes list from teradata database from working application

Hi,This is Chandu, I am new to this forum, I got a question from one interview, He asked me like how many AMPs and Nodes are you using for your application.?

Can some one help me how to know the AMP s list and Nodes list from teradata database using query. Thanks in Advance...
12 REPLIES
Enthusiast

Re: How to know AMPs and Nodes list from teradata database from working application

Hi Chandu, welcome to the Teradata forums.

To find out the node list:
sel distinct NodeId from DBC.ResUsageSpma;

To find out AMP count in the whole Teradata system:
sel hashamp()+1;

To list down all the AMP Ids (if ResUsageSvpr is in non-summary mode):
sel distinct VprId from DBC.ResUsageSvpr where VprType='AMP';
Enthusiast

Re: How to know AMPs and Nodes list from teradata database from working application

how to find the how many parsing engines required the minmum to maximum 

plz send me the exact answer

thq 

ratnam

Senior Apprentice

Re: How to know AMPs and Nodes list from teradata database from working application

Minimum: 1

maximum: 10 per node

exact answer: 42

Dieter

Enthusiast

Re: How to know AMPs and Nodes list from teradata database from working application

Dieter,

Is it

exact answer: 42

or you want to say 

exact answer: 2

I m not clear

Senior Apprentice

Re: How to know AMPs and Nodes list from teradata database from working application

Of course it's 42: en.wikipedia.org/wiki/42_(Hitchhiker's_Guide_to_the_Galaxy)

How should i know what's the exact answer to a vague question?

Dieter

Re: How to know AMPs and Nodes list from teradata database from working application

resgeneralinfo view in DBC gives most of the information about the system.

Enthusiast

Re: How to know AMPs and Nodes list from teradata database from working application

hi i am new in teradata, 

how to write the simple bteq script use procedure 

plz send me a sample one procedure

ith loading sample data

ratnam

Enthusiast

Re: How to know AMPs and Nodes list from teradata database from working application

I would use MonitorPhysicalConfig and MonitorVirtualConfig of PMPC UDFs.

Teradata Employee

Re: How to know AMPs and Nodes list from teradata database from working application

DBC.ResUsageSpma does contain some detail about the nodes and their respective vprocs.

Try using the following query.

Select Distinct
NodeID
,NodeType
,VProcType1 || ': ' || TRIM(VProc1) AS AMPs
,VProcType2 || ': ' || TRIM(VProc2) AS PEs
,VProcType3 || ': ' || VProc3 AS GTW
,VProcType4 || ': ' || VProc4 AS RSG
,VProcType5 || ': ' || VProc5 AS TVS
,VProcType6 || ': ' || VProc6 AS VProc6
,VProcType7 || ': ' || VProc7 AS VProc7
From DBC.ResUsageSpma
Order By NodeID

Hope it helps.

Farhan