zOs/SQL/TADM33

delete -- db_name, dd_name, runtime
    from oa1p.tadm33a1
    where (db_name, dd_name, runtime) in
    ( select db_name, dd_name, runtime
         from
         ( select db_name, dd_name, runtime
                -- numeriere vom neuesten zu ältesten
               , row_number() over ( partition by db_name, dd_name
                                     order by runtime desc) rn
             from oa1p.tadm33a1
         ) t3
         where rn > 10   -- erste 10 Utilities behalten
         fetch first 10 rows only
    )
;
rollback