AMPs PEs and NODEs in a Teradata Datawarehouse.

Database
Enthusiast

AMPs PEs and NODEs in a Teradata Datawarehouse.

Hi Guys,

Could anyone of you can tell me how to get the number of AMPs,PEs and NODEs in a Teradata Datawarehouse ?

Regards,
Ansh
4 REPLIES
Enthusiast

Re: AMPs PEs and NODEs in a Teradata Datawarehouse.


Try out this query ....

No of Nodes:

Select count(distinct nodeid) from dbc.resusagescpu;

Amps per node:

Select nodeid,count(distinct Vproc) from dbc.ResCpuUsageByAmpView;

Thanks,
Sen
Enthusiast

Re: AMPs PEs and NODEs in a Teradata Datawarehouse.

hi
to find number of AMPS:

select hashamp()+1

cheers:-)
Enthusiast

Re: AMPs PEs and NODEs in a Teradata Datawarehouse.

Thanks guys for your reply....but still I have got no info to get the number of PE's in a Datawarehouse?

Re: AMPs PEs and NODEs in a Teradata Datawarehouse.

In case you are using TD 12.0, you may make use of the Workload Management OpenAPI (provided by Teradata) :

select count(t1.ProcId) Nodes, sum(t1.AmpCount) Amps, sum(t1.PECount) PEs
from table (MonitorPhysicalResource()) as t1
where t1.Status = 'U'
;

You need to have an EXECUTE FUNCTION privilege on SYSLIB for the query to be successful.

grant execute on syslib to userid;