Andy,

Yes, the "select ... from occupancy" would surely help except our v3
ADSM server shows totally bogus numbers for physical_mb and logical_mb.
The "query occ" interface shows the correct numbers.  The "select"
interface appears to repeat the values for the first listed filespace
within each storage pool.  Assuming I have to use the "query occ"
interace until the "select" interface is fixed, how do I get "query occ"
to display wide columns??  SET SQLDISPLAYMODE WIDE does not appear to
work on "query occ".

Thanks to you others out there who also wrote to suggest I use query
occ.

Bob