zOs/SQL/RUNUPDS

select -- t.card, t.cardf, t.nPages, t.nPagesF, t.spacef, t.AVGROWLEN,
       s.space, s.spacef, s.nActive, s.nActiveF,
                        sum(r.totalRows), sum(r.statsInserts),
                        sum(r.nPages) "nP",
                        sum(r.space)  "sp",
                        sum(coalesce(r.totalRows, r.statsInserts, 0)),
        t.name, t.creator
    from sysibm.systables t
        join sysibm.systableSpace s
        on t.dbName = s.dbName and t.tsName = s.name
            and t.dbid = s.dbId
        left join sysibm.sysTableSpaceStats r
        on t.dbName = r.dbName and t.tsName = r.name
            and t.dbid = r.dbId and s.psid = r.psid
    where t.name = 'TMF150A1' and t.creator = 'OA1T'
    group by t.creator, t.name, t.card, t.cardf,
                       s.space, s.spacef, s.nActive, s.nActiveF
;
update
         sysibm.systablePart p
    set


                                spaceF=       3151080

    where p.tsname = 'A150A' and p.dbName  = 'MF01A1T'
;
select        space, spacef,  s.nActive, s.nActiveF
    from sysibm.systableSpace s
    where s.name = 'A150A' and s.dbName  = 'MF01A1T'
;
-- rollback