Teradata : Finding the health of vprocs and the number of AMPs in a Teradata system and other basic commands

Share via:

Finding the health of vprocs and the number of AMPs in a Teradata system and other basic commands

As stated in earlier posts, AMPs are responsible for handling their share of distributed data. That makes it very important for all the AMPs to be online at any point of time for queries to run successfully on the Teradata box. Whenever we have an unplanned/planned outage on a Teradata box, it is very necessary to check the stats of all the AMPs and other VPROCs once the database is back up in service. This can be done by using a utility known as vprocmanager in Teradata. Vprocmanager can be run directly from the console of the primary Teradata node and it gives the status of all the AMPs.

 

Below is an example:

 

 

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (22 votes, average: 4.95 out of 5)
Loading...

6 thoughts on “Teradata : Finding the health of vprocs and the number of AMPs in a Teradata system and other basic commands

  1. Finding the health of vprocs and the number of AMPs in a Teradata system and other basic commands ,A BREIF ARTICLE and easy to understand

Add Comment