zOs/SQL/REOTSTJ

select *
    from s100447.treoRunJob
    where job = 'A540769'
    order by tst desc
    fetch first 10 rows only
;
select *
    from s100447.treoRunPart
    where tst = '2011-09-11-10.01.50.258516'
    order by tst desc, rng, part
;
select *
    from s100447.treoRunTSStats
    where tst = '2011-09-11-10.01.50.258516'
    order by tst desc, rng, partition
;
select *
    from s100447.treoRunIXStats
    where tst = '2011-09-11-10.01.50.258516'
    order by tst desc, rng, partition
;