zOs/SQL/SPACEIX

select t.dbName, t.tsName, char(min(t.name), 12),
    sum(t.spacef)*1024 "tsSp", sum(t.cardf) "tsC",
    count(*) "indexes", sum(i.spacef)*1024, sum(i.nLeaf) "leaf"
    from sysibm.systables t
    left join sysibm.sysindexes i
    on i.tbcreator = t.creator and i.tbName = t.name
    where t.type = 'T' and t.dbName = 'TSTNAKNE'
    group by t.dbName, t.tsName