|
Archives of the TeradataForumMessage Posted: Wed, 26 Oct 2005 @ 18:21:45 GMT
Not very efficiently. The only ways to get a list of nodes (or AMPs etc.) are 1) via Teradata utilities (already mentioned in other posts) 2) via the Performance Monitor API 3) [using SQL] By selecting NodeId from one of the Resusage views or tables. You must Group By the NodeId and, for efficiency, select todays date in the where clause. This should get you a list of all nodes. (Depending which table you select from you may only get OnLine nodes.) Mike Dempsey
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||