zOs/SQL/STOR

select 'alter tablespace ' || strip(dbname) || '.' || strip(tsname)
     || ' alter partition ' || char(partition)
     || ' priqty 720;'
    from sysibm.systablepart
    where dbname = 'PW01A1P' and pqty = 12
    order by dbname asc, tsname asc, partition asc
;
x
select dbname, tsname, partition, pqty, sqty,
        pqty * 4 / spacef pp, sqty * 4 / spacef sp,
        spacef, cardf
    from sysibm.systablepart
    where dbname = 'PW01A1P'
    order by pqty asc, pp asc
;
x
select dbname, tsname, partition, pqty, sqty, space, spacef,
          dsnum, extents,
          card, cardf, avgrowlen, cardf*avgrowlen / spacef / 1000
    from sysibm.systablepart
    where dbname = 'PW01A1T'
    order by dbname asc, tsname asc, partition asc