How we can find the No of AMP'S for the teradata Database

Database

How we can find the No of AMP'S for the teradata Database

Hi All,

I am new to teradata and i have a couple of questions regarding the AMP's.

1.How can we findout the number of AMP'S for the Teradata database through DBC views or by any other way.
2.When creating a database how can we decide on the number of AMP's required, what are the things we need to consider for this?

Please answer the above questions as I am little bit confused regarding these.

Thanks for the help in advance
5 REPLIES
Enthusiast

Re: How we can find the No of AMP'S for the teradata Database

1.
select Vproc from Acctg where VprocType='AMP' group by Vproc;

Lists all the AMPs.

2.
Use PUT (Parallel Upgrade Tool)
Enthusiast

Re: How we can find the No of AMP'S for the teradata Database

You can do a SELECT HASHAMP()+1 to get the total number of Amps in the system.

The number of Amps in the system are governed by various factors like your system capacity, number of nodes etc.... in general most of the configurations have 8 AMPs per node
N/A

Re: How we can find the No of AMP'S for the teradata Database

object acctg doesn't exist... how to find the number of awts
Junior Supporter

Re: How we can find the No of AMP'S for the teradata Database

MaxAMPWorkerTasks can be found from DBS Control utility. Its Internal Field 4

4.  MaxAMPWorkerTasks  


Abhishek Jadhav
Enthusiast

Re: How we can find the No of AMP'S for the teradata Database

You need to use "dbc.acctg"