finding node and data capacity for the database

Database
Enthusiast

finding node and data capacity for the database

Can anybody please let me know how to find the node information(like how many nodes in the system) and capacity of the system(how many terabytes of data) using SQL query?
1 REPLY
Enthusiast

Re: finding node and data capacity for the database

Ihope you are concerned about the diskspace and count of vporc and nodes on your teradata system

Run the below query to know the diskspace

select sum(maxperm) from dbc.diskspace;

Oneway that I can suggest to know the count of vprocs and Nodes is to see status in Vprocmanager.I beleive you can also query resusage and ampusage tables to get this information.