zOs/SQL/CATRTSSZ

with p as
(
   select *
     from sysibm.sysTablePart
     where dbName = 'QZ01A1P' and tsName = 'A006A'
)
select p.partition, r.totalRows, int(p.cardF + r.statsInserts) aRows
       , r.space rSpace
       , case when p.cardF < 100 then p.spaceF
              else p.spaceF * (p.cardF + r.statsInserts) / p.cardF end
             aSpace
    from p join sysibm.sysTableSpaceStats r
      on p.dbName = r.dbName and p.tsName = r.name
        and p.partition = r.partition
    order by p.dbName, p.tsName, p.partition