zOs/SQL/BERTS

set current path oa1p;
select substr(name,1, 5),
    substr(fosFmtE7(sum(totalRows)), 1, 7) "tot",
    substr(fosFmtE7(sum(case when substr(name, 6, 2) = '01'
                        then totalRows else 0 end)), 1, 7) "i01",
    substr(fosFmtE7(sum(case when substr(name, 6, 2) = '02'
                        then totalRows else 0 end)), 1, 7) "i02",
    substr(fosFmtE7(sum(case when substr(name, 6, 2) = '03'
                        then totalRows else 0 end)), 1, 7) "i03",
    substr(fosFmtE7(sum(case when substr(name, 6, 2) = '04'
                        then totalRows else 0 end)), 1, 7) "i04"
    from sysibm.sysTableSpaceStats r
    where dbName = 'BE01A1P' and name like 'A01%'
    group by substr(name,1, 5)
    order by 1
    ;,;
select totalRows, r.*
    from sysibm.sysTableSpaceStats r
    where dbName = 'BE01A1P' and name like 'A01%'
    order by name, partition