Try this ...
Where $1 is the node name



select SUM(PHYSICAL_mb)AS "TOTAL" -
from OCCUPANCY where node_name=upper('$1')









Theresa Sarver <tsarver.IFMC AT SDPS DOT ORG> on 02/05/2003 10:31:03 AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>








 To:      ADSM-L AT VM.MARIST DOT EDU

 cc:      (bcc: Michael Raine/NOTES)



 Subject: Calculating space used








Hi all;

Does anyone have a script that calculates the total spaced used per node (and
possibly per stg pool)?

Thank you;
Theresa


****************************************************************************
All electronic communications, including company provided email, are the sole
property of Allfirst.  This system may not be used to transmit, receive or
download solicitations or offensive, vulgar or otherwise disruptive messages or
materials, including, but not limited to, those that violate Allfirst's policies
regarding Equal Employment Opportunity and Sexual Harassment.  All messages
transmitted by or received through the Allfirst email system shall be regarded
as non-personal, business communications.  Employees are reminded to only use
this system for legitimate business purposes.  Allfirst reserves the right to
monitor, intercept and retrieve electronic communications in the normal course
of business.