zOs/SQL/RUNUPD

select t.card, t.cardf, t.nPages, t.nPagesF, t.spacef, t.AVGROWLEN,
                        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,
                       t.nPages, t.nPagesF, t.spacef, t.AVGROWLEN
;
update
         sysibm.systables t
    set card = 162982084    , cardf = 162982084,
        nPages = 7285306    ,
        nPagesF= 7285306    , spaceF=       31510800,
        AVGROWLEN = 200     ,
        statstime = current timestamp
    where t.name = 'TMF150A1' and t.creator = 'OA1T'
;
select card, cardf, nPages, nPagesF, spacef, AVGROWLEN
    from sysibm.systables  t
    where t.name = 'TMF150A1' and t.creator = 'OA1T'
;