Heres a select that gives the same info as show volumeusage

select distinct volume_name,node_name from -
  volumeusage where node_name = upper('$1') -
  and stgpool_name = upper('$2')





"MC Matt Cooper (2838)" <Matt.Cooper AT AMGREETINGS DOT COM> on 12/18/2001 
08:58:25 PM

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

To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: John Naylor/HAV/SSE)
Subject:  Re: Incremental forever -- any problems?



Be wary of that SHOW VOLUMEUSAGE nodename command.  It just killed my 4.1.3
system on OS390 2.7
Matt