Is this what you are looking for?

q auditoccup =  select node_name,backup_mb,archive_mb, spacemg_mb,total_mb
from auditocc
q occup=  select
node_name,type,filespace_name,stgpool_name,num_files,physical_mb,logical_mb
from occupancy


Sung Y. Lee
E-mail sunglee AT us.ibm DOT com



                      Alex Paschal
                      <AlexPaschal@FREIGH        To:       ADSM-L AT VM.MARIST 
DOT EDU
                      TLINER.COM>                cc:
                      Sent by: "ADSM:            Subject:  Re: SQL to do q 
auditoccupancy?
                      Dist Stor Manager"
                      <[email protected]
                      DU>


                      05/01/2002 05:14 PM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"





Auditocc = select node_name, sum(physical_mb) from occupancy group by
node_name

occupancy = select * from occupancy where ......
          = select node_ame, filespace_name, sum(physical_mb) from
occupancy
group by node_name, filespace_name

Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail