Find out Teradata AMP (vprocs) Count

event 2020-12-26 visibility 622 comment 0 insights
ios_share
Twitter Facebook LinkedIn
more_vert
insights Stats
Raymond Raymond
Raymond
Raymond
articleArticles 578
imageDiagrams 58
commentComments 303
loyaltyKontext Points 6373
 Code Snippets & Tips

Code snippets and tips for various programming languages/frameworks. All code examples are under MIT or Apache 2.0 license unless specified otherwise. 

Teradata AMPs are the parallel distributed storage and computing unit in a Teradata server. We can use HASHAMP function to calculate the total AMP count (virtual processors) in a Teradata system.

HASHAMP function

HASHAMP function returns the identification number of the primary AMP corresponding to the specified hash bucket number. If no hash bucket number is specified, HASHAMP returns one less than the maximum number of AMPs in the system.

Code snippet

SELECT HASHAMP()+1 AS "AMP Count"
More from Kontext
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts