The select looks just fine!

You don't say why the results look fishy?  Have they not scaled the
way you expect?

If you are using a copy pool then you will be double counting.  The
occupancy table includes rows for all the copypools as well as primary
pools.


You can either halve the output of your select...

Or include
        where stgpool_name in ('BACKUPPOOL', 'TAPEPOOL', 'ANOTHERTAPEPOOL')
in your select.

Or you can wait for "audit licenses" to complete and use the
"auditocc" table if you just want MB.


Another random thought is that the logical_mb and the physical_mb
numbers are often widly different.  It depends on how the parts of an
aggreate files expire, and how well files pack into logical blocks.


Russell