zOs/SQL/CATIXGBP

select count(*), gbpCache, sum(p.spacef) runSp,
           sum(float(r.space)) realSp
       FROM  SYSIBM.SYSINDEXPART p
       join sysibm.sysIndexes i
       on     i.creator = p.ixCreator
          and i.name    = p.ixName
       left join sysibm.sysindexSpaceStats r
       on    r.DBID       = i.dbid
         and r.ISOBID     = i.isobid
         and r.PARTITION  = p.partition
    group by gbpCache
;
x
   SELECT B.IXCREATOR, B.IXNAME, B.GBPCACHE
       WHERE B.IXCREATOR = A.CREATOR
       AND   B.IXNAME    = A.NAME
       AND   B.GBPCACHE NOT IN (' ')
       )