How to identify the AMPs belong to the same cluster in Teradata

Database
Enthusiast

How to identify the AMPs belong to the same cluster in Teradata

Hello,

Tables with fallback protection ensures that copy of each row is available on fallback AMPs in the same CLUSTER. I have few questions on this.

1) How do i identify that what all AMPs are the part of same cluster. 

2) Is there any console utility in teradata to check the AMPs which are grouped together?

3) I have 156 AMPs in my system, if i want to check the "No. of Clusters" and "No of AMPs in each cluster" in my system then how to check that. 

Any help would be definitely appreciated.

1 REPLY
Enthusiast

Re: How to identify the AMPs belong to the same cluster in Teradata

Sharib,

Console utility Qryconfig will provide this.

Rglass